locked
What is the best way to backup SCCM? RRS feed

  • Question

  • Hello,

    We have SCCM 2012 R2 in our environment.  The hierarchy consists of 1 primary server only running 2008 R2 on a VMware virtual machine. The SQL servers are clustered using SQL 2008 R2 on 2008 R2 physical servers.  What is the best way to backup our environment?  Should we utilize SQL backups in tandem with VMware backups or use the build in site backup task?

    My preference is the site backup site but I've noticed some hesitation from our server admins to go this route.  Can anybody tell me what the Microsoft best practice is... and If you have any source links that would be fantastic. 

    Thanks for your help!

    Friday, February 7, 2014 1:28 PM

Answers

  • Hi,

    SCCM 2012 since the SP1 allows SQL Backup as all information is stored in the database.

    The SQL backup is using compression and therefore is smaller and easier to manage.

    I'll advise you to go through a SQL Maintenance Plan.

    http://stevethompsonmvp.wordpress.com/2013/06/07/sql-server-backup-recommendations-for-configuration-manager/

    Friday, February 7, 2014 1:33 PM
  • Hi,

    In Configuration Manager 2012 R2 it is supported to use SQL backup instead of the builtin task, it has some advantages like compression and the fact that the SQL guys can use their normal backup strategy. Then for the Primary Site server I would us a traditional file backup and NOT a VM backup as you have the database on another machine so restoring the VM of the Primary Site server would case for problems as items are written to the database that doesn't exist anymore.

    I hope that helps.

    Regards,
    Jörgen


    -- My System Center blog ccmexec.com -- Twitter @ccmexec

    Friday, February 7, 2014 1:35 PM

All replies

  • Hi,

    SCCM 2012 since the SP1 allows SQL Backup as all information is stored in the database.

    The SQL backup is using compression and therefore is smaller and easier to manage.

    I'll advise you to go through a SQL Maintenance Plan.

    http://stevethompsonmvp.wordpress.com/2013/06/07/sql-server-backup-recommendations-for-configuration-manager/

    Friday, February 7, 2014 1:33 PM
  • Hi,

    In Configuration Manager 2012 R2 it is supported to use SQL backup instead of the builtin task, it has some advantages like compression and the fact that the SQL guys can use their normal backup strategy. Then for the Primary Site server I would us a traditional file backup and NOT a VM backup as you have the database on another machine so restoring the VM of the Primary Site server would case for problems as items are written to the database that doesn't exist anymore.

    I hope that helps.

    Regards,
    Jörgen


    -- My System Center blog ccmexec.com -- Twitter @ccmexec

    Friday, February 7, 2014 1:35 PM
  • Hi,

    In Configuration Manager 2012 R2 it is supported to use SQL backup instead of the builtin task, it has some advantages like compression and the fact that the SQL guys can use their normal backup strategy. Then for the Primary Site server I would us a traditional file backup and NOT a VM backup as you have the database on another machine so restoring the VM of the Primary Site server would case for problems as items are written to the database that doesn't exist anymore.

    I hope that helps.

    Regards,
    Jörgen


    -- My System Center blog ccmexec.com -- Twitter @ccmexec

    When you say "file backup" what exactly are you meaning by that?
    Friday, February 7, 2014 1:49 PM
  • I use the built-in backup task.

    John Marcum | http://myitforum.com/myitforumwp/author/johnmarcum/

    Friday, February 7, 2014 2:07 PM
  • Is it supported to use CIFS shares for the backup?
    Friday, February 7, 2014 2:11 PM
  • http://social.technet.microsoft.com/Forums/systemcenter/en-US/8cfd9b57-1484-4b88-9f33-13ecce47f88a/sccm-and-cifs-compliant-filesystems?forum=configmgrgeneral

    Same answer as in this thread but reversed. As long as your share is able to be mapped with ComputerAccount permission then yes

    Friday, February 7, 2014 2:21 PM
  • Hi,

    afaik SQL Backup using DPM is not supported while using named instances of a clustered SQL environment only if u use the default instance name. You can find more information on this at http://technet.microsoft.com/en-us/library/gg712697.aspx#BKMK_DPMBackup

    i would definately go for the builtin site backup maintainance task as this is also the best practice. For more information on this, please have a look at http://technet.microsoft.com/en-us/library/gg712697.aspx (consider using afterbackup.bat as well)

    Pls keep in mind that a scheduled maintainance taks not only backs up your site database but specific registry keys and specific folders and files as well.

    cheers


    • Edited by sven_thimm Friday, February 7, 2014 2:41 PM
    • Proposed as answer by sven_thimm Friday, February 7, 2014 2:45 PM
    • Unproposed as answer by sven_thimm Friday, February 7, 2014 2:45 PM
    • Proposed as answer by tailsor Tuesday, February 11, 2014 8:14 PM
    Friday, February 7, 2014 2:33 PM
  • Hi,

    With file backup I meant a backup of the Primary Site server and where you have your source files for your packages/applications and so on as well so you can restore the site server in case of a crash.

    Here is an example from Steve on the backup using SQL instead and the compression rate, there is nothing wrong with the builtin task, just saying that this is an alternative.

    Regards,
    Jörgen


    -- My System Center blog ccmexec.com -- Twitter @ccmexec

    Friday, February 7, 2014 3:08 PM
  • i would definately go for the builtin site backup maintainance task as this is also the best practice. For more information on this, please have a look at http://technet.microsoft.com/en-us/library/gg712697.aspx (consider using afterbackup.bat as well)

    Pls keep in mind that a scheduled maintainance taks not only backs up your site database but specific registry keys and specific folders and files as well.


    The registry keys/values and folders "backed up" by the maintenance task are not used and are thrown away during a restore so they are just useless overhead.

    afterbackup.bat can be useful, but the primary use of afterbackup is to not overwrite previous backups by renaming them or adding additional files/folders to backup set. The first is not an issue using a SQL backup tool and the second is also easy to do using any SQL backup method.

    Using the site maintenance task is not a best practice for 2012 -- using a native SQL backup or backup tool is sufficient and has many advantages as pointed out by the others in this thread.


    Jason | http://blog.configmgrftw.com

    Friday, February 7, 2014 3:27 PM