How to Back Up the MOM Database and Management Packs (325612)

MORE INFORMATION

MOM 2000 uses a single database to store all data and configuration information. This SQL Server database is named OnePoint, and OnePoint contains all the information about the MOM server. This information includes agent information, configuration information, and any customizations in the MOM Administrator console. Management Pack information is also stored in this database. Because of these conditions, it is important to have a backup of this database. A backup may be useful if there is a problem with the database server, and rebuilding the MOM environment is not an option.

IMPORTANT: The procedure in this article only works correctly if the following conditions exist:

• There will be no name changes on the MOM server. The computer name must be the same as it was before the backup.
• The same Configuration Group Name must be used.
• The MOM service account and password will be the same as it was before.

Back up the MOM Server database regularly so that you have the most up-to-date copy of the MOM configuration information. A complete backup of the OnePoint database is all that you must have to restore a MOM site.

Create a Backup

To create a database backup:

1. Start SQL Server Enterprise Manager, expand a server group, and then expand a server.
2. Expand Databases, right-click the database, point to All Tasks, and then click Backup Database.
3. In the Name box, type the backup set name. Optionally, type a description of the backup set in the Description box.
4. Under Backup, click Database - complete.
5. Under Destination, click Tape or Disk, and then specify a backup destination. If no backup destinations appear, click Add to add an existing destination or to create a new one.
6. Under Overwrite, click one of the following options:
   • Append to media to append the backup to any existing backups on the backup device
   • Overwrite existing media to overwrite any existing backups on the backup device
7. Optionally, click to select the Schedule check box. You can then schedule the backup operation for a later time.
8. Optionally, click the Options tab, and then click to select one or more of the following check boxes:
   • Verify backup upon completion causes the backup to be verified at the end of the backup process.
   • Eject tape after backup causes the tape to be ejected when the backup operation has completed. This feature is only available with tape devices.
   • Check media set name and backup set expiration causes the backup media to be checked to prevent accidental overwrites. In the Media set name box, type the name of the media to be used for the backup operation. Leave this blank when you are only specifying the backup set expiration.
9. If either of the following conditions exist, click to select the Initialize and label media check box under Media set labels, and then type the media set name and media set description:
   • It is the first use of the backup media.
   • You want to change an existing media label. The media can only be initialized and labeled when the media is overwritten.

Restore a Backup

To restore a backup from a backup device:

1. Start SQL Server Enterprise Manager, expand a server group, and then expand a server.
2. Expand Databases, right-click the database, point to All Tasks, and then click Restore Database.
3. In the Restore as database box, type or select the name of the database to restore. Note that a new name for the database automatically determines the new names for the database files that are restored from the database backup.
4. Click From device, and then click Select devices.
5. Under Restore from, click Tape or Disk, and then select a device from which to restore. If no devices appear, click Add to add an existing backup device or to create a new one. In the Restore Database dialog box, click View Contents, and then click the backup set to restore. This option scans the backup set for the backup content information and can be time consuming, especially when you are using tape devices. If you already know the backup set to restore, type the backup set number in the Backup number box.
6. Under Restore backup set, click one of the following options:
   • Database - complete restores a database backup.
   • Database - differential restores a differential database backup.
   • Transaction log applies a transaction log backup.
   • File or filegroup restores a file or filegroup backup. You must specify the name of the file or filegroup.
7. Optionally, click the Options tab, and then click one of the following options:
   • Leave database operational. No additional transaction logs can be restored if no more transaction log backups are to be applied.
   • Leave database nonoperational, but still makes it possible to restore additional transaction logs if another transaction log backup is to be applied.
8. Click OK to start the restore process.

Back Up Management Pack Information

To back up any management pack information:

1. In the MOM Administrator console, open Rules and Processing Rule Groups.
2. Right-click the processing rule that you want to back up, and then click Export Management Pack.
3. Select a location in which to save the .akm file.
4. Click OK to save the management pack.

Restore Management Pack Information

To restore a Management Pack:

1. In the MOM Administrator console, open Rules and Processing Rule Groups.
2. Locate the saved management pack file.
3. Optionally, you can select whether to merge this data or overwrite any existing data.
4. Click Import to start importing the .akm file.
5. Click OK to acknowledge the import process has completed. The Management Pack is imported and is located in the MOM Administrator console under Processing Rule Groups.