Updated Steps for Moving Operations Manager 2012 Databases


Back when Operations Manager 2007 was released, I blogged here – http://blogs.technet.com/b/mgoedtel/archive/2007/08/06/update-to-moving-operationsmanager-database-steps.aspx regarding
a script that needed to be executed after you moved the OperationsManager database from one SQL server to another.  With Operations Manager 2012, the steps documented here – http://technet.microsoft.com/en-us/library/hh278848.aspx, still overlooks the fact you need to update the Master database on the destination SQL server in order to complete this operation successfully. 

It should be noted the same issue/symptoms will occur after you move the data warehouse database (OperationsManagerDW).

Attached is a .ZIP file containing the two scripts for updating the Master database on the SQL servers hosting either the OperationsManager or OperationsManagerDW database. 

 

OM2012_UpdateMasterDB.zip

Comments (1)

  1. Jarrad says:

    Hi Matt. Not sure of you are the right person but that link you have for the Ops 2012 DB move has an error. It does not show the reg keys that need to be changed.