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?