How to Restore Operations Manager Databases
Use the following procedure to restore a System Center 2012 – Operations Manager database using Microsoft SQL Server Management Studio. This procedure applies to databases on SQL Server 2008 R2 and SQL Server 2008 R2 SP1.
If you want to resize the operational database, you must resize it by using SQL Server. For more information, see Microsoft SQL Server in the TechNet Library.
To restore a database backup
Start SQL Server Management Studio.
In the Connect to Server dialog box, select the appropriate values in the Server type drop-down combo box, in the Server name box, and in the Authentication box.
In Object Explorer, expand Databases, and then select the OperationsManager, OperationsManagerAC, or OperationsManagerDW database.
Right-click the database, point to Tasks, and then click Restore.
Click Database to open the Restore Database dialog box.
On the General page, the name of the restoring database appears in the To database list.
In the To a point in time text box, either retain the default (the most recent possible) or select a specific date and time by clicking the browse button, which opens the Point in Time Restore dialog box.
To specify the source and location of the backup sets to restore, click the From Device option.
Click Browse to open the Specify Backup dialog box.
In the Backup media list box, select one of the listed device types. To select one or more devices for the Backup location list box, click Add.
In the Select the backup sets to restore grid, select the backups to restore. This grid displays the backups available for the specified location.
In the Restore options panel, select the Overwrite the existing database option.
In the Restore the database files as options panel, verify the original database file name and path are correct.
For the Recovery state options, specify the state option Leave the databases ready to use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored.
Click OK to restore the database.