Restoring MOM Databases

  • Article

Depending on the failure scenario, you might need to restore any of the MOM databases, the master database or the MSDB database. During a database restore, all connections to the database must be closed, and the MOM Service on Management Servers should not be running, otherwise the restore fails. To prevent this, take the database offline. You can use SQL Server to verify that there are no open connections to the database.

Use SQL Server to restore MOM databases, following restore procedures in your organization. Refer to the SQL Server documentation set for information about restore procedures, and restore best practices.

To restore the Operational database

  1. Use SQL Server to restore the Operational database

  2. Grant access for the DAS account to the OnePoint database.

  3. Using Enterprise Manager, select Security, and then select Login.

  4. Select DAS Account, then right-click Properties, and select Database.

  5. Select OnePoint, and then select the check-box for db_owner.