Book Excerpt

Establishing an SCOM 2007 backup schedule

System Center Operations Manager 2007 Unleashed This chapter excerpt from System Center Operations Manager 2007 Unleashed, by Kerrie Meyler, Cameron Fuller, John Joyner and Andy Dominey, is printed with permission from Sams Publishing, Copyright 2008.

Click here for the chapter download or purchase the entire book here.

In addition to identifying required files for backup, you should also establish a regular backup schedule. Tables 12.1 and 12.2 give suggested time frames for backing up significant databases and files used by Operations Manager 2007.

Establishing a daily backup schedule for those files that change regularly helps ensure any data loss affects less than 24 hours worth of data. It also makes it possible to meet your Service Level Agreements (SLAs) if you have backups of the information necessary to restore any OpsMgr components!

TABLE 12.1: OpsMgr Databases with Recommended Backup Schedule

Database Name Type of Data Recommended Backup Schedule
Operations database OperationsManager (default) This database contains the majority of the OpsMgr configurations, settings, and the current operations data. The loss of this database would require completely reconfiguring Operations Manager and result in the loss of all operational data. Daily
Data Warehouse database OperationsManagerDW (default) This database holds all the data used for reporting and can be large. The loss of this database would mean the loss of all historical operations and reporting data. Daily or Weekly
SQL Reporting database ReportServer This database holds all the report definitions, as well as cached report information and snapshots. The loss of this database would mean having to reimport reports and re-create subscriptions. Minimal impact.

If you have installed ACS, it will have its own reporting subsystem and instance of the ReportServer database.

ACS database OperationsManagerAC (default) This database tracks Security Event logs being cleared by an agent. A new table is created daily for that day's events. Daily
Master database master This database is a SQL system database and records the system information for SQL Server 2005. Back up the Master database for every SQL Server instance in your OpsMgr environment. Daily or when changes
Msdb database msdb This database is a SQL system database and holds information on all jobs scheduled through SQL Server. It can be found on every SQL Server instance in your OpsMgr environment. Although OpsMgr 2007 does not use this database as it schedules its maintenance internally, if you create any jobs yourself within SQL Server (backups or database maintenance, for example), you should back up the Msdb database to retain that information. Monthly or as needed

TABLE 12.2: Significant Files with Recommended Backup Schedule

File Type of Data Recommended Backup Schedule
Management packs and reports (.mp and .xml files) Source files for management packs and reports. Enable more granular restoration than entire Operations database; also used for moving management packs and reports from one management group to another. After changes to management packs or reports
Custom files Encryption key files, the IIS metabase, and so on. As needed

 Home: Introduction
 Tip 1: Roles of key SCOM files and databases
 Tip 2: Establishing a backup schedule
 Tip 3: Database grooming
 Tip 4: Backing up the RMS encryption keys
 Tip 5: Backing up management packs
 Tip 6: Backing up reports
 Tip 7: Disaster recovery planning

This was first published in June 2008

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: