If any server-scoped objects were created after the master backup, recreate them.If any databases were created after the master backup, reattach them.Remove the -m startup parameter and then restart the server.The server shuts down automatically when the restore ends.Start the server with the -m startup parameter.
If you have to restore master and you don’t know how, or you don’t have a backup of master, then you have to rebuild master – go to reason #2 above.
Restore your backup of model (you have that too, right? Otherwise you’ve lost all the customizations you made.). Restore your backup of msdb (you have that, right? Otherwise you’ve lost all your Agent Jobs, backup history, SSIS packages,…). Create all server-scoped objects (do you have a script for that handy too? And, do you know what all the server-scoped objects were before the disaster?). Reattach all databases (do you have a script for that handy?). If you have to rebuild master, you’re going to have to:. Which amount of resultant downtime would you rather deal with? If master is damaged so that the instance will not start, you can either rebuild master or re-install SQL Server. I’m very pleased to see the results – almost 60% of respondents have successfully restored or rebuilt the master database, either in practice or for real.įor the rest of you, if you’re responsible for recovering SQL Server during a disaster, then IMHO there’s no excuse for either not knowing how to fix master or not having tried it. 1 x “I’ve successfully practiced both rebuilding and restoring…but…only after being burned by having to rebuild master on production without backups”. 1 x “I work for CSS – I feel like it’s cheating to say “Yep, both restore and rebuild, in a drill and in real life”. Turn sql server off, if it isn’t already, copy the files…” Currently, I have copies of the master data and log files saved for emergency restorations. 2 x “I once carefully followed the documented procedure for restoring the master database and it failed every time. 3 x “Moving the other databases to a new server seems easier…”. 3 x “I’ve rebuilt master due to collation change”. 
3 x “I both practice rebuilding and restoring and have also done both in DR scenarios”.4 x “Done it years ago but not practiced recently”.It’s been a hectic January with client work and preparations for our 2014 classes so I haven’t blogged as much as I wanted, but I have lots of blog posts coming up over the next month!Ī few weeks ago I kicked off a survey on whether you’ve ever tried or had to restore or rebuild master – thanks to all those who responded.
0 kommentar(er)
