Moving your OperationsManager database – SCOM 2012

Recently I had to move our OperationsManager database to a different server as part of testing a disaster recovery plan. While the Microsoft procedure for this (http://technet.microsoft.com/en-us/library/hh278848.aspx) is quite in-depth there is something to be aware of if you upgraded your environment from SCOM 2007.

Step 8 will ask you you to update the table dbo. MT_Microsoft$SystemCenter$ManagementGroup in your OperationsManager database however if you upgraded this table does not exist. Instead you will need to update the old SCOM 2007 management group table dbo.MT_ManagementGroup.

Step below:

Update the operational database with the new database server name.

  1. Open SQL Server Management Studio.
  2. Expand Databases, OperationsManager, and Tables.
  3. Right-click dbo. MT_Microsoft$SystemCenter$ManagementGroup (or dbo.MT_ManagementGroup if you upgraded from SCOM 2007), and then click Edit Top 200 Rows.
  4. Change the value in the SQLServerName_6B1D1BE8_EBB4_B425_08DC_2385C5930B04 column to reflect the name of the new SQL Server-based computer.
  5. Save the change.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.