Microsoft Office Tutorials and References
In Depth Information
Restoring SQL databases with DPM
In the Recoverable item pane right-click on the content database you want to
recover data from and select Recover .
The DPM Recovery Wizard will pop up, make sure your selection is correct
then click Next .
Specify the type of recovery you would like to perform such as the options
that appear in the following screenshot and then click Next :
° If you choose to recover the database to the original SQL instance
you will have the option to leave the database as operational or as
non-operational. If you choose operational the database will be
ready to use as soon as the recovery is completed. If you choose
non-operational the database will be restored to the SQL server but it
will not be live. Choosing non-operational gives you the opportunity
to restore additional transaction logs or perform other tasks on the
database if you need to before putting it back into production.
° If you choose to recover your database to an alternate SQL server
instance you will need to browse to the SQL server and specify the
location for the .mdf and .ldf SQL database files. You can also
change the name of the the recovered database on the alternate SQL
instance during the alternate SQL server instance recovery type.
° Choosing to recover the database to a network folder or tape is the
same process as recovering files, folders, or volumes to a network
folder or tape. This will give you the SQL database backup file and
you can move it around as you choose from here.
On the next screen you can choose to retain the security settings of the
original location, or the new location. At this point you can also choose
to add network throttling, SAN recovery, and the behavior in regards to
versions and to receive a notification when the restore is complete. Click
Next to continue.