You’ve been working with SQL Server for a couple of years, but you’re not really sure what’s going on in the System Databases folder. What gets stored in Master, Model, and MSDB? What processes use them? In the event of a crash, should you restore them? Brent Ozar will give you an introductory tour in this half-hour video:
Introducing the System Databases: Master, Model, MSDB
Hi! I’m Brent Ozar.
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.
Want to advertise here and reach my savvy readers?
2 Comments. Leave new
Should I backup resourcedb like recommended by sql soldier?
http://www.sqlsoldier.com/wp/sqlserver/day31of31daysofdisasterrecoverybackupandrestoreoftheresourcedatabase#comment-579074
I guess in a worst scenartio when I lose the C: drive, I can re-setup the SQL server.
If your ResourceDB was corrupted, odds are other things on the system are also corrupted, and that’s when you fail over somewhere else. If you experience corruption in ResourceDB, I don’t want you learning about ResourceDB for the first time under that kind of stress. If you regularly encounter corruption in ResourceDB, then you’ve got even bigger problems – you need to fix the root cause.