my personal blog about systemcenter

Data Protection Manager Recover SQL master database

Had a question today about the ability to recover the SQL master database if the SQL server wasnt operational.

To set the scene for the converation we did the following

Image

Installed the Data Protection Manager on the SQL 2012 server , created a brand new fresh and shiny protection group , added the SQL instance

Image

Created short term recovery this was after all just a test

Image

And a backup every hour kept for the last 5 days

 

Image

And as always with Data Protection Manager Sucess is an option 🙂

Image

And a few minutes later we now have a full backup of the SQL server

Image

And lets try to add the human factor

Image

Twice

Image

And after that we have a non functional SQL Server

 

Image

And as we can see the reason if lack of master databases

 

Image

DPM to the rescue , enter recovery select the master database

Image

Option One , Recover to original instance (otherwise restore to folder and copy the files manually)

 

Image

And leave database operational as we are not recovering from additional logs

 

Image

Verify server/files

Image

And 35 seconds later the database is recovered without incident

 

Image

Recovery is complete , SQL instance is restarted and we can fire the blogger that deleted the master database