Chris Nackers

ConfigMgr / SCCM

SQL Server Backup Recommendations for Configuration Manager

2013-06-07

From the archive (2013). Written for the tools of the time, so some details may be out of date.

Great post by fellow MVP Steve Thompson.

Read his full post here.

In Configuration Manager 2012 SP1 and later, note that you have the ability to recover a site (secondary sites don’t count) using a standard, native SQL Server database backup.

From the following link: http://technet.microsoft.com/en-us/library/gg712697.aspx

“Configuration Manager can recover the site database from the Configuration Manager backup maintenance task or from a site database backup that you perform by using another process. For example, you can restore the site database from a backup that is performed as part of a Microsoft SQL Server maintenance plan.”

Why is this important?

The standard ConfigMgr backup task will simply copy all of the database data and log files to the backup folder location. During the SQL Backup task, you have the ability to specify compression for a database backup.