Microsoft SQL Server 2008 Disaster Recovery

This article describes necessary steps to perform a Disaster Recovery for Microsoft SQL Server 2008. This document assume you already has a backup for all your databases (user and system) and also you have a new server installation with the same settings your failed server had (SQL installed on the same path, with same server collation, same version and same service packs).

Start your new SQL Server and go to Microsoft SQL Server  Management Studio (MSSMS) and select the MSDB perform a right click and select TASK/RESTORE/DATABASE from menu, then select the location where your backup is stored, and click OK to restore it.

The second database to restore is MODEL. We perform the same steps as last one but with a little difference, we need to select the option "Overwrite the existing database (WITH REPLACE)":

Finally the last database to restore is MASTER. To restore this database we need to configure it to single user, to do it, go to, "Microsoft SQL Server 2008 / Configuration Tools / Sql Server Configuration Manager" then select "SQL Server Services / SQL Server (MSSQLSERVER)"

 After that open the next window and click on "Advanced" and select "Startup Parameters" and on the right side of the window at the start of the values we add "-m" (without quotes) and the click "OK"

Then stop all SQL Services and start only "SQL Server (MSSQLSERVER)"

Now go to MSSMS and select MASTER database and restore it, with the setting "Overwrite the existing database " and click "OK".

Once restored MASTER database we need to return the original settings removing the "-m" value, and we stop and start all SQL services.

After that you will see listed(but not working) all your databases with all your server's configuration, but you still need to restore all your User databases to finish your Disaster Recovery.

SHARE

About Robert SA