Step by Step Procedure to Restore SCOM 2012 R2 Databases after crash or Disaster:

Step by Step Procedure to Restore SCOM 2012 R2 Databases after crash or Disaster:

Many times for various reason we have to restore the SCOM databases.Follow the below procedure

• 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.
• Click Connect.
• 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.
• Make sure whenever you restore always restore OperationsManager, and OperationsManagerDW database. Orelse youw ill face 31552 issue.