![]() 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”. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |