Book Image

Microsoft System Center Data Protection Manager 2012 R2 Cookbook

By : Robert Heldblom, Robert Hedblom
Book Image

Microsoft System Center Data Protection Manager 2012 R2 Cookbook

By: Robert Heldblom, Robert Hedblom

Overview of this book

If you are a DPM administrator, this book will help you verify your knowledge and provide you with everything you need to know about the 2012 R2 release. No prior knowledge about System Center DPM is required, however some experience of running backups will come in handy.
Table of Contents (21 chapters)
Microsoft System Center Data Protection Manager 2012 R2 Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Restoring a SQL Server database to its original location


This recipe will cover how to restore a SQL database to its original location. This is one of the most common scenarios that a DPM administrator must be able to perform.

Getting ready

This restore operation is the most common and the easiest to perform. There are some options that you should consider regarding the restore process, and they are explained in this recipe.

How to do it…

  1. Open the DPM console and click on Recovery. Browse the tree on the left-hand side of the console and click on the SQL database that you want to restore. Choose the date and the recovery point time for restore. Right-click on the database and click on Recover… to start Recovery Wizard.

  2. In the Review Recovery Selection step, verify that you have chosen the right database and click on Next > to continue.

  3. In the Select Recovery Type step, choose Recover to original instance of SQL Server (Overwrite database) and click on Next >.

  4. In the Specify Database State...