How to move a MOM 2000 OnePoint database to a new location

This article explains how to move a Microsoft Operations Manager (MOM) OnePoint database to a new location if such a move becomes necessary.

Move involving only the OnePoint database from one SQL server to another

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

We do not recommend that you move the Microsoft Operations Manager OnePoint database.

Moving the MOM OnePoint database is not a standard maintenance procedure. However, you may need to move the OnePoint database for various reasons, including but not limited to:

• Volume size restrictions.
• Performance improvements, for example separating the database from the logs.
• Relocation of the database to a fault-tolerant volume.

We recommend that you move the OnePoint database only if you must move it for one of these reasons. Moving the OnePoint database can cause serious problems that may necessitate a reinstallation of the server. Microsoft Product Support cannot guarantee that any resulting problems can be solved.

Note The following steps are for moving the MOM database from one SQL server to another. If your SQL server is also the MOM server (DCAM - Database Access Server, Consolidator and Agent Manager) then there may be a need to make additional modifications to the MOM server registry keys and/or database table modifications, which are discussed in the second section below - Move that involves also the DCAM server.

1. Install SQL server on new destination computer.
2. Install MOM Database component by running MOM setup.
3. Quit OnePoint service on the current database computer and stop the OnePoint service on all DCAMs.
4. Backup the current OnePoint database to a file.
5. On the new SQL server (installed in step 1 above), in SQL Enterprise Manager, under the Restore menu, use the From Device option to restore the OnePoint database, and then select the backup file created in step 4.
6. On the DCAM server, start Regedt32 and change the following registry values from the current SQL server name to new SQL server name:
   • HKEY_LOCAL_MACHINE\Software\Mission Critical Software\DASServer\DataSource Value
   • HKEY_LOCAL_MACHINE\Software\Mission Critical Software\OnePoint\Configurations\Configuration Group Name\Operations\Database Value
   • HKEY_LOCAL_MACHINE\Software\Mission Critical Software\OnePoint\Databases
   For each of these keys, delete the current SQL Server value, and then create a new SQL Server name value. MOM will recreate DCAM Key(s) as needed under this new key once it restarts.
7. Navigate to the following registry key:
   HKEY_LOCAL_MACHINE\Software\Mission Critical Software\OnePoint\Configurations\Default\MCS Applications\Operations GUI\Databases\<no name> value
   Change it from old SQL server name to new SQL server name.
8. On your Web Console computer, locate the Instal.stm file under the WebConsole folder wherever it is installed. (The default location is <%SystemDrive%>\Inetpub\Wwwroot\WebConsole. Change the old database server name in this file to the new database server name.
9. Restart OnePoint service on the DCAM server(s).
10. Make the same registry changes as above on each DCAM in this configuration group (except for the very last one preceding which you would make on all MOM admin console machines).

Note For information in the MOM 2005 Operations Guide about how to move the Microsoft Operations Manager 2005 database, visit the following Microsoft Web site:

Move involving the SQL server that is also a DCAM server and/or MOM Web Console server

In addition to the changes discussed above on the SQL side, if the server you are moving also hosts either the MOM DCAM role or Web Console role, then there are additional changes to be made especially to the Configuration table in the OnePoint database. Also note that moving the DCAM server to a machine with a different name may have an effect on the managed nodes (servers running MOM agent) if this is the only DCAM in the configuration group. Please consult Microsoft Product Support Services first if that is the case.

If you are moving all the components of the Microsoft Operations Manager 2000 (MOM) server to a new hardware platform, you need to install the MOM server on the new platform. To do this:

1. Perform a custom installation of MOM on the new computer.
2. Type the Configuration Group name precisely as it appears on the existing MOM installation.
3. Once MOM install is completed, start SQL Enterprise Manager.
4. Right-click the Configuration table in the OnePoint database, click Open Table, and then click Return all Rows.
5. Change all entries where DataCategory = URL to read DataCategory = databasename, where databasename is the name of the new database computer.

Note The URL entries need to remain as they are with the exception of using the name of the SQL Server computer that you moved the database to. For example, if an existing entry in the table looks like this or this the corrected entry looks like this or this

For more information about this topic, click the following article number to view the article in the Microsoft Knowledge Base: