Matt Goedtel on Operations Management

Posts in this blog are provided "AS IS" with no warranties, and confers no rights as specified in the Terms of Use

Updated Steps for Moving Operations Manager 2012 Databases

Updated Steps for Moving Operations Manager 2012 Databases

  • Comments 1
  • Likes

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. 

 

Attachment: OM2012_UpdateMasterDB.zip
Comments
  • 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.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment