SCCM 2012 How To Backup Your Server easily!

 

How to Backup maintenance task  on Sccm 2012

 

Hi

Today we gonna try to add a simple maintenance task on our sccm2012 R2 serverto backup our SQL database from SCCM

 

Source:  http://technet.microsoft.com/en-us/library/gg712697

 

You can automate backup for Configuration Manager sites by scheduling the predefined Backup Site Server maintenance task. You can back up a central administration site and primary site, but there is no backup support for secondary sites or site system servers.

When the Configuration Manager backup service runs, it follows the instructions defined in the backup control file (<ConfigMgrInstallationFolder>\Inboxes\Smsbkup.box\Smsbkup.ctl).

 

Log File of The backup : Smsbkup.log

Placed: \\sccm-server\logs\site

 

 

You can modify the backup control file to change the behavior of the backup service. Site backup status information is written to the Smsbkup.log file. This file is created in the destination folder that you specify in the Backup Site Server maintenance task properties.

 

Enable backup maintenance Task

1. In the Configuration Manager console, click Administration.
2. In the Administration workspace, expand Site Configuration, and then click Sites.
3. Select the site in which you want to enable the site backup maintenance task.
4. On the Home tab, in the Settings group, click Site Maintenance Tasks.
5. Click Backup Site Server and then click Edit.
6. Select Enable this task, and then click Set Paths to specify the backup destination. You have the following options:

 

 

Local drive on site server for site data and database:

Specifies that the backup files for the site and site database are stored in the specified path on the local disk drive of the site server. You must create the local folder before the backup task runs.

Network path (UNC name) for site data and database:

Specifies that the backup files for the site and site database are stored in the specified UNC path. You must create the share before the backup task runs.

Local drives on site server and SQL Server:

Specifies that the backup files for the site are stored in the specified path on the local drive of the site server, and the backup files for the site database are stored in the specified path on the local drive of the site database server. You must create the local folders before the backup task runs.

Security notes

• The Local System account on the site server must have Write NTFS file system permissions to the local folder for the site server backup.
• The Local System account on the computer that is running SQL Server must have Write NTFS permissions to the folder for the site database backup.
• The computer account of the site server and the computer account of the SQL Server, if SQL Server is installed on another computer, must have Write NTFS and share permissions to the shared network folder.
• The computer account of the site server must have Write NTFS permissions to the folder that you create on the site server. The computer account of the SQL Server must have Write NTFS permissions to the folder that you create on the site database server. This option is available only when the site database is not installed on the site server.

 

 

 

 

Verify the backup

 

Verify that the Site Backup maintenance task is completed successfully by reviewing any of the following:

• Review the timestamp on the files in the backup destination folder that the Backup Site Server maintenance task created. Verify that the timestamp has been updated with a time that coincides with the time when the Backup Site Server maintenance task was last scheduled to run.
• In the Component Status node in the Monitoring workspace, review the status messages for SMS_SITE_BACKUP. When site backup is completed successfully, you see message ID 5035, which indicates that the site backup was completed without any errors.
• When the Backup Site Server maintenance task is configured to create an alert if backup fails, you can check the Alerts node in the Monitoring workspace for backup failures.
• In <ConfigMgrInstallationFolder>\Logs, review Smsbkup.log for warnings and errors. When site backup is completed successfully, you see Backup completed with a timestamp and message ID STATMSG: ID=5035.