How to Restore the Service Manager Database in the Lab Environment
Applies To: System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager
Use the following procedure to restore the production Service Manager database by using Microsoft SQL Server 2008 R2. Steps might differ for Microsoft SQL Server 2012.
To restore the Service Manager database
After you connect to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database.
Right-click the database, point to Tasks, and then click Restore. The Back Up Database dialog box appears.
Click Database, which opens the Restore Database dialog box.
On the General page, the name of the restoring database appears in the To database list. To create a new database, enter its name in the list.
In the To a point in time box, either retain the default (Most recent possible) or select a specific date and time by clicking the Browse button to open the Point in Time Restore dialog box. For more information, see How to: Restore to a Point in Time (SQL Server Management Studio).
To specify the source and location of the backup sets to restore, click either From database or From device.
In the Select the backup sets to restore grid, select the backups to restore. For more information, see Restore Database (General Page).
To view or select the advanced options, in the Select a page pane, click Options.
In the Restore options pane, in the following list of options, select the one that is most appropriate for your situation:
Overwrite the existing database
Preserve the replication settings
Prompt before restoring each backup
Restrict access to the restored database
For more information, see Restore Database (Options Page).
Optionally, you can restore the database to a new location by specifying a new restore destination for each file in Restore the database files as. For more information, see Restore Database (Options Page).
In the Recovery state pane, in the following list of options, select the one that is most appropriate for your environment:
Leave the database ready to use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored. (RESTORE WITH RECOVERY)
Note
Select this option only if you are restoring all of the necessary backups at this time.
Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY)
Leave the database in read-only mode. Undo uncommitted transactions, but save the undo actions in a standby file so that recovery effects can be reverted. (RESTORE WITH STANDBY)
For more information, see Restore Database (Options Page).
-----
For additional resources, see Information and Support for System Center 2012.
Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----