Thursday, May 19, 2011

SCOM: How to Backup System Center Operations Manager 2007 R2

HI All,
Yesterday I was working on “How to Backup System Center Operations Manager 2007 R2”. I go through different document and posts and read few documentations and I think I should also share this information with you.
Our first step is to plan what to backup. So here is the list
  1. Note down SCOM servers IP Address, Subnet, Gateway
  2. Note down the Location of System Center Operations Manager Installation Path
  3. Backup SCOM Databases
    1. OperationsManager (Operational Database)
    2. OperationsManagerDW (Dataware house Database)
    3. OperationsManagerAC (Audit Collection Server Database)
    4. ReportServer (Reporting Server Database)
    5. ReportServerTempDB (Reporting Server Temporary Database)
    6. Master (SQL Server Master Database)
    7. MsDbData (Msdb database)
  4. IIS 6.0 Metabase or IIS 7.0 configuration
  5. Root Management Server Encryption Key
  6. Create List of All Management Pack Installed
  7. Backup of Unsealed (customised) Management packs
  8. SCOM Registry Keys
  9. Backup your files
Let’s Start
  1. I have noted down the IP-Address of SCOM including Subnet mask, Gateway IP and DNS Entries.
  2. I noted down the location where is my SCOM in Installed, in my case it is installed on “C:\Program Files\System Center Operations Manager 2007
  3. Backup Databases
Operations Manager Operational Database (OperationsManager) 
The OperationsManager database contains almost all of the Operations Manager environment configuration settings, agent information, management packs with customizations, operations data, and other data required for Operations Manager to operate properly.
Note:     If your backup procedure sets the OperationsManager database to be offline during backup, Operations Manager caches incoming data, and then, after backup is complete, Operations Manager stores that data in the database.
Open “Microsoft SQL Server Management Studio” , Expend the “Database” , Right click on “OperationsManager”, choose “Tasks” and click on “Backup
SqlBackup-1
For now, I am choosing “Backup type = Full” and Name of the Backup and Backup Destinations, (for now I am backing up the data in to my network folder (Click on “ADD” to define the location of where you want to keep your backup”) and click on “OK
SqlBackup-2
After “Backup” process finish , you can see the data on your backup destination folder.
SqlBackup-3

Do the same for all SCOM Databases ( OperationsManagerDW, OperationsManagerAC,ReportServer,ReportServerTempDB,Master,MsDbData)
  • Reporting Databases (just a brief intro)
Operations Manager Reporting uses the following databases:
· Operations Manager 2007 data warehouse (OperationsManagerDW)
· SQL Server Reporting Services databases (ReportServer and ReportServerTempDB)
The OperationsManagerDW database contains all of the performance and other operational data from your Operations Manager environment. SQL Reporting Services then uses this data to generate reports such as trend analysis and performance tracking.
  • ACS Database (just a brief intro)
The Audit Collection Services (ACS) database, OperationsManagerAC, is the central repository for events and security logs that are collected by ACS forwarders on monitored computers.
The OperationsManagerAC database can grow significantly depending upon how many ACS forwarders send events to the ACS database and the filters configured to control what events are written to the database.
  • Master Database (just a brief intro)
The master database is a system database, which records all of the system-level information for a Microsoft SQL Server system, including the location of the database files. It also records all logon accounts and system configuration settings. The proper functionality of the master database is key to the operation of all of the databases in a SQL Server instance.
  • MSDB Database (just a brief intro)
The MSDB database, Msdbdata, is a SQL system database, which is used by the SQL Server agent to schedule jobs and alerts and for recording operators. The proper functionality of the MSDB database is key to the operation of all the databases in a SQL Server instance.

Backup IIS Metabase
My SCOM installed on “Windows 2003 server”  so I am using IIS 6.0. To backup IIS 6.0 metabase, Go to RUN (windows key + R) and type “%systemroot%\system32\inetsrv\iis.msc” and hit OK
IIS
Right click on your “Computer Name” and then click on “All tasks” and choose “Backup/Restore configuration
IISMetabackup-1-SCOCM
Click on “Create Backup” and then type the “Configurations backup Name” and then hit on “OK
IISMetabackup-2-SCOCM
By Default all Metadata are stored in “%systemroot%\system32\inetsrv\MetaBack
IISMetabackup-4-SCOCM

Backup Root Management Server Encryption Key
To restore SCOM from scratch we need “RMS Encryption Key”. You must backup “RMS Encryption Key” and store it on secure locations.
To backup an Encryption Key go to “C:\Program Files\System Center Operations Manager 2007” double click SecureStorageBackup.exe
BackupEncryptionKey-1-SCOM
When you double click “SecureStorageBackup.exe”, an “Encryption Key Backup and restore wizard” Open, click on NEXT
BackupEncryptionKey-2-SCOM
in “Select Action” choose to “Backup Encryption Key” and click on “NEXT”
BackupEncryptionKey-3-SCOM
Now “Specify the location of Backup File” where you want to save your encryption key, name it and click Next
BackupEncryptionKey-4-SCOM
Specify the password to protect the key and SCOM will ask for this password when we restore it after restorations after failure.
BackupEncryptionKey-5-SCOM
Click on “Finish”
BackupEncryptionKey-6-SCOM

Create List of All Management Pack Installed
It is handy to keep the latest list of all “Management Pack” installed in SCOM. The list will helps us to download or restore them. To create an List of All Management Packs, open “Operations Manager Shell” and type :
Get-ManagementPack | Export-csv c:\ManagementPackList-May-2011.csv
List-managementpack
CDrive
this will export all management packs in to .CSV file which we can import to excel and see the list of sealed and unsealed Management Packs
for example : Import the CSV file in to Microsoft Excel and create a filter on Data and the you are view list of All management packs by “sealed” or “Unsealed”
Filter

Backup of Unsealed (customised) Management packs
Open “System Center Operations Manager Console” click on “Monitoring” , click on “Management Packs” and sort the Management Packs by “Sealed” or “Unsealed”, choose the “Management pack” which you want to export, then right click it and choose “Export management pack”
Export-Mp-Gui
choose the location where you want to save “Management Pack” and click on “Ok”
Export-Mp-Gui-1
Exported “Successfully” , do the same for every unsealed Management Pack
Export-Mp-Gui-2

Backup SCOM Registry Keys
I read on some posts that we need to backup SCOM registry Keys and it seems a good backup practice. so open “Registry editor" navigate to “My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Operations Manager\” and export the whole key.
RegistryBackupLocation-SCOM
Right Click on “Microsoft Operations manager” ,Click on “Export
Export registry
Choose the location where to save registry keys, and choose the file name make sure you have selected (Selected branch), and click on “Save
Export registry-1

Backup your files
The last thing to backup is your installation folder. :-).
Folder
As per Microsoft documentations when you restoring your folder make sure you don’t restore the “Heath service State” folder.

That’s all :-)
Hope it helps someone

Thanks
Aman Dhally

3 comments:

  1. I appreciate your efforts because it conveys the message of what you are trying to say. It's a great skill to make even the person who doesn't know about the subject could able to understand the subject . Your blogs are understandable and also elaborately described. I hope to read more and more interesting articles from your blog. All the best.
    Data Science course in kalyan nagar
    Data Science course in OMR
    Data Science course in chennai
    Data science course in velachery
    Data science course in jaya nagar
    Data Science interview questions and answers

    ReplyDelete