Backing Up MOM Databases

If there are established guidelines and procedures for backing up databases in your organization, then follow those guidelines and procedures to back up the MOM databases and the SQL system databases. When backing up, ensure that all data, up to the point of failure, is backed up, and that it can be later restored, if necessary.

Note

The MOM Reporting database uses a simple recovery model, which truncates all transactions after completion. Therefore, backing up the transaction log file is not useful. When backing up the Reporting database, use only a differential backup or a complete backup.

Use SQL Server to back up MOM databases, manually, or schedule SQL Server tasks to ensure that the databases are backed up on a regular basis. Refer to the SQL Server documentation set for information about backup procedures, and backup best practices.

SQL Server allows access to the database while it is being backed up. This allows you to continue to use MOM if you need to; however, you might notice a decrease in performance until the backup is complete.

Note

If your backup procedure sets the MOM database to be offline during backup, then MOM caches incoming data, and then, after back up is complete, MOM stores that data in the database.