Restoring a SQL Server Database

The steps used to recover a SQL Server database using DPM differ slightly depending on if you are trying to restore the database to its original instance of SQL Server or to an alternate location. Use the following steps to restore a database to its original instance of SQL Server:

1. While logged on to the DPM server as a domain user account that is a member of the local administrators group, open the DPM 2012 Administrator Console.

2. Once the console has loaded, click Recovery on the navigation bar.

3. Using either the Browse or Search tabs, find the database that needs to be recovered, as shown in Figure 11.10.

Figure 11.10 Choosing which SQL database to recover.

4. Once you have selected the database to ...

Get Microsoft® System Center 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.