Transcript SCCM * Disaster Recovery

SCCM – Disaster Recovery
Do you feel lucky punk?
Matthew H. Teegarden
www.EmptyGarden.info
[email protected]
Systems Software Engineer
Lifetouch Inc.
Steve Thompson
www.stevethompsonmvp.wordpress.com/
[email protected]
Senior Consultant
Softchoice
Matthew H. Teegarden
@TheEmptyGarden
MCT, MCSE, MCSA
Steve Thompson
@Steve_TSQL
Microsoft MVP, MMS/Teched
IT/Dev connections Speaker
Working with SCCM since SMS 1.2
23 yr. with SQL/Data, SMS since 1995!
Have pit tickets to both nights of Pearl Jam at
Wrigley Field
BBQ
SCCM – Disaster Recovery
How to feel good about your SCCM
disaster recovery plan
SCCM – Disaster Recovery
SMS Writer Service
• smsbkup.ctl file – what gets backed up
• Stops SCCM services – restarts after back up is complete
• Remote registry must be enabled
Back up a SCCM site
• SCCM backup maintenance task
• Files used
• Smsbkup.ctl file
• Afterbackup.bat file
• Destinations
• Local Drive on Site Server
• Local System account needs write permissions
• SQL Server local system account needs write permissions
SCCM – Disaster Recovery
Back up a SCCM site (continued)
• Destinations
• Network UNC path
• Local System account needs write permissions
• SQL Server local system account needs write permissions
• Local drives on the Site Server and the SQL Server
• This would be for environments where SQL is not installed on the SCCM Site Server
• The backup tasks creates a new backup each time it runs, overwriting the
old backup
• System Center Data Protection Manager
• Select the SMS Writer service from the SCCM server data source list
• Select the database
SCCM – Disaster Recovery
Back up a SCCM site (continued)
• System Center Data Protection Manager
• Select the SMS Writer service from the SCCM server data source list
• Select the database
• SQL Server backup
• Can use compression – big benefit
• If this is your backup method, you should consider looking at the
smsbkup.ctl file and backing up the data listed.
SCCM – Disaster Recovery
Back up a SCCM site (continued)
• What else should I back up?
• Reporting Services
• Databases
• ReportServer DB
• ReportServerTempDB DB
• Reporting Services encryption keys using the SQL Server Reporting Services Configuration Manager
• Report Designer files – Report Definition (.RDL), Report Model (.SMDL), Shared Data Sources (.RDS), Data
Views (.DV), Data Sources (.DS), Report Server Project (.RPTPROJ), and Report Solutions (.SLN)
• Report Services Files located in [SQL Server Installation Direcotry]\MSRS12.MSSQLSERVER\Reporting
Services\ReportServer
• Rsreportserver.config
• Rssvrpolicy.config
• Rsmgrpolicy.config
• Reportingservicesservice.exe.config
• Web.config for both the Report Server and Report Manager ASP.NET applications
• Machine.config for ASP.NET
SCCM – Disaster Recovery
Back up a SCCM site (continued)
• What else should I back up?
• Content Files
• SCCMContentLib folder
• Package Source Files
• SELECT * FROM v_Package
• SCUP 2011 - Custom Updates
• On the computer that runs Updates Publisher, browse the Updates
Publisher 2011 database file (Scupdb.sdf) in
%USERPROFILE%\AppData\Local\Microsoft\System Center Updates
Publisher 2011\5.00.1727.0000\. There is a different database file for each
user that runs Updates Publisher 2011.
SCCM – Disaster Recovery
Recover a SCCM site
• Must use the same version and edition of SQL Server
• Run Setup.exe from the CD.latest directory
• Select Recover a site *
• Site Server Recovery Options
• Recover the site server using an existing backup
• You will need the folder that the Backup Site Server task used
• Reinstall the site server
• Must use the same Site Code and DB name
• Site Database Recovery Options – demo forthcoming
• Recover the site database using a backup set
• Create a new database for this site
• Use a site database that has ben manually recovered
SCCM – Disaster Recovery
Post Recovery Tasks
•
•
•
•
•
•
•
•
•
•
•
•
The recovery report is saved to C:\ConfigMgrPostRecoveryActions.html
Re-enter user account passwords
Re-enter Sideloading Keys
Recreate Microsoft Intune Subscription
Configure SSL for Site System Roles that use IIS
Reinstall hotfixes
Recover Custom Reports
Recover Content Files
Recover Custom Software Updates (SCUP)
Recover USMT
Update Certificates for Cloud DP’s
Reprovision Intel AMT-based computers
SCCM – Disaster Recovery
SCCM Secondary Site
• How to backup
• Step 1: Don’t
• Recover Secondary Site
• Use the Recover Secondary Site action from the Sites node
SCCM – Disaster Recovery
Links:
https://technet.microsoft.com/enus/library/gg712697.aspx
Demo
Let’s break stuff!!!
SCCM – Backup Discussion
The WHAT
Backup CAS and Primary Sites
1) Files
2) Databases
The HOW
1) Built-in Maintenance Task
2) Data Protection Manager (3rd party software)
3) Native SQL Server Backup Task
SCCM – Built-in Maintenance Task
Advantages
• Simple to enable
• No SQL experience
• Scripts – need afterbackup.bat
Disadvantages
• No compression as database files are copied
• Many files copied are discarded during restore
• Missing other databases
SCCM – SQL Backup
Native SQL Server Backup
Advantages
• Compression
• Email notifications
• CM Services continue to run!
• Other Databases
• ReportServer
• WSUS
• Ability to run scripts!
• CD.LATEST
SCCM – Site recovery from SQL
CM Site Recovery from SQL Backup
Note: Supported since CM 2012 SP1!
Demo
Properly setup SQL backup
Break Stuff!!
Recover from SQL backup
SCCM – Disaster Recovery
Links:
https://stevethompsonmvp.wordpress.com/2014/02/24/configmgr2012-site-backup-and-recovery-overview/
https://stevethompsonmvp.wordpress.com/2013/06/07/sql-serverbackup-recommendations-for-configuration-manager/
http://blog.coretech.dk/kea/configuring-backup-in-configmgr-currentbranch/
And Then …