At a minimum, this recovery instance should be the same version, edition, and patch level, and it should have the same selection of features and the same external configuration (hostname, cluster membership, and so on) as the original instance. (No, none of us learned it the smart way.In the event of disaster recovery, the instance where the master database is being restored to should be as close to an exact match to the original as possible. We just launched our new Fundamentals of Database Administration class – an online video course that teaches you a lot of things you should have been taught when you first took this job. Kendra says: You may have more in your master database than you think! It just takes one ‘oops’ on a deployment script, and there you go. After all, those objects take hardly any space, and we don’t need to restore them over to our DR environment. Now, having said all this, I’m completely okay with putting utility stored procedures in the master database – things like sp_WhoIsActive, sp_Blitz®, and the like. You’re failing over to another server because things are already going wrong – why make things worse by doing something you rarely practice? Plus, if you’re failing over due to corruption, you probably don’t want to bring over a possibly corrupt master database.Įven if you could restore it, you’ll lose data. You can’t do transaction log backups for the master database, so you’ll lose whatever changes were made since the last full backup. While you can indeed restore one server’s master database over to another, it’s just not a good idea. In the event of a disaster, we don’t usually restore master. Starting Windows with a full C drive is not a lot of fun. I’d rather not create tables that might grow when I’m not looking, and then possibly run my server’s limited boot drive out of space. The default installation parameters for SQL Server throw master, model, and msdb all on the C drive. System databases are often located on space-limited drives. But what’s the real deal? Why is this such a bad idea? Growing up as a young boy, my elementary teachers always warned me about the perils of putting stuff in master.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |