Full System Recovery

Last Post 20 Dec 2011 11:43 AM by BMWGuy. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
BMWGuy
New Member
New Member

--
06 Dec 2011 11:41 AM
If I had a disaster (server blew up) and had to recover it from backups, what order would I restore the databases in? Here's the scenario:
-Server blows up
-Windows engineer obtains new server and installs exact same OS, IP address, etc
-Server is handed off to SQL DBA
-I install base SQL Server from DVD
-I install all SPs and hotfixes needed

Now for the question:

What order do I restore the databases? User DBs, Master, MSDB  or  Master, MSDB, UserDBs  or third option?



russellb
New Member
New Member

--
06 Dec 2011 01:42 PM
First, master is a matter of choice and your DR strategy. Also depends whether or not you're storing user objects in master.

If you're going to restore master, do it first. Then msdb and user DBs (order doesn't matter).

So...short answer:
1. master
2. msdb
3. user dbs
rm
New Member
New Member

--
07 Dec 2011 04:38 AM
If you choose to restore all system and user dbs, new server should have same disk config and folders as on old server.
gunneyk
New Member
New Member

--
10 Dec 2011 01:01 PM
I also want to add that you can now slipstream SQL Server, SP & the cumulative updates so that you can do one install instead of 3 which should make the recovery process a little faster.
BMWGuy
New Member
New Member

--
20 Dec 2011 11:43 AM
Good point...saves time doing it that way.

You are not authorized to post a reply.

Acceptable Use Policy