(No, none of us learned it the smart way. 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. It would be ok to add a stored procedure like spwhoisactive to the master database. As part of a major initiative involving the implementation of several new Microsoft-based applications, this. ![]() The default installation parameters for SQL Server throw master, model, and msdb all on the C drive. SQL Server will allow objects to be added to the master database, but that should rarely happen. Change the master database to MS SQL Server. System databases are often located on space-limited drives. ADR is introduced in SQL Server 2019 (15.x) and improved in SQL Server 2022 (16.x). 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. |