Relocating the Database to an Active/Passive Clustered SQL Server

  • Article

You might want to relocate the MOM database to a clustered SQL Server, while preserving the configuration data in the MOM OnePoint database.

To relocate the MOM database to a clustered SQL Server

  1. Install the MOM 2005 database on the replacement computer according to the "Installing the MOM Database on the Cluster Nodes" section in Chapter 7 of the Microsoft Operations Manager 2005 Deployment Guide.

  2. Stop the MOM Service on all the management servers in the configuration group. If MOM to MOM Product Connector (MMPC) is installed, stop the momcomm service. Back up a copy of the OnePoint database. Detach the new OnePoint database from the clustered SQL Server instance.

  3. Reattach the copy of the OnePoint database from the old computer onto the new clustered SQL Server instance.

  4. On the first MOM Management Server start Regedt32.exe, and change the following registry values from the current SQL Server Instance to the new clustered SQL Server Instance (format: ClusterName\SQLClusterInstance):

    • 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

  5. Restart the MOM service. If MOM to MOM Product Connector (MMPC) is installed, restart the momcomm service.

  6. On each of the remaining MOM Management Servers in this management group, make the same changes that you made for the first Management Server.

    Note

    To configure MOM Reporting servers, if you update the database server name and update the DTS configuration to point to the new database, MOM will recognize the new database server instead of updating the old instance because the domain/computer identification of the new server would not match the old. All data collected for the old database will be disconnected.

  7. When the management group is running without error, you can uninstall the original MOM Database component through Add/Remove Programs on the old MOM Database computer.