Introducing the System Databases: Master, Model, MSDB
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:
Free, 3× a week
Get my new posts by email
Three posts a week, plus a Monday roundup of the best database news from around the web.
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.