Moving the Operations Database

Moving the Operations Database

In earlier versions of OpsMgr, Microsoft provided instructions for moving the operational database to another database server (see and This information is not yet available for Operations Manager 2007, so we are providing the following steps:

  1. Stop all OpsMgr services on the Root Management Server. If you have multiple management servers, you will need to stop the services on those machines as well.
  2. Using SQL Server Management Studio, connect to the source database server and backup the OperationsManager database.
  3. Connect to the destination server and create Windows/AD SQL logins for the following OpsMgr accounts : SDK, MSAA, and DWWA.
  4. Copy the OperationsManager database backup file to the destination database server, and restore the database to the destination database server.
  5. Using SQL Server Management Studio on the destination database server, right-click on the OpsMgr SDK login and go to properties.
  6. In the properties for the Operations Manager account, go to the User Mapping page and click on the OperationsManager database. Ensure the following database roles have been assigned to the SDK account:
    • Db_datareader
    • Db_datawriter
    • Db_ddladmin
    • Db_owner
    • Dbmodule_users
    • Sdk_users
  7. Click OK.
  8. On the RMS and each of your management servers, open REGEDIT and browse to HKLM\Software\Microsoft\Microsoft Operations Manager\3.0\Setup, update the string called DatabaseServerName to reflect the name of the new database server.
  9. Reboot the RMS and other management servers.

Many thanks to Kendra Thorpe of Vanderbilt University for helping with this information!

This entry was posted in Operations Manager 2007. Bookmark the permalink.

One Response to Moving the Operations Database

  1. Pingback: Moving the ACS Database to new Drives on the Same System | Operations Manager

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s