Blog

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:

Brent Ozar
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.

I’m mostly a figurehead here at Brent Ozar Unlimited. My true skills are menu advice, interpretive dance, and reading Wikipedia.
Brent Ozar on sabtwitterBrent Ozar on sablinkedinBrent Ozar on sabinstagramBrent Ozar on sabgoogleBrent Ozar on sabfacebook
↑ Back to top
  1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

css.php