Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Which SQL Server system database is more important: master or resource?

If the resource database is damaged, can the database engine work?

Can the system work with only the master database? If not, which system databases are necessary?

share|improve this question

closed as not constructive by gbn, Aaron Bertrand, Martin Smith, Nick Chammas, Mark Storey-Smith Mar 13 '12 at 23:03

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

8  
Why does it matter? Both are required. –  Martin Smith Mar 13 '12 at 14:23
4  
This is like asking, "which part of my car is more important, the wheels or the engine?" –  Aaron Bertrand Mar 13 '12 at 15:49
    
What is more important, front end or back end? You need them both. –  datagod Mar 13 '12 at 20:28
    
@user8365: The sub questions seem okay but the abstract headline is probably why it was closed. –  crokusek Jun 3 at 16:34

2 Answers 2

Both the master and resource DB is important.

If the master DB becomes corrupt, you can still restart your server by creating a new master DB. You will loose your server principals and other data that are stored in the master, but at least you will be up and running. Once you recreate your logins (hopefully these were scripted) then you have access to your data.

The resource DB contains the sys schema. I am not sure if you can just copy these from another instance if there are not much changes done to these. Will have to see if there is anybody else who had this issue.

share|improve this answer

They are both 100% required. However, mssqlsystemresource is read-only, and specific to your version/patchlevel, so it's easy to restore, in theory.

share|improve this answer
    
resource can't be backed up and restored in the traditional database sense. It must be a file backup and restore to the directory. –  Thomas Stringer Mar 13 '12 at 14:41

Not the answer you're looking for? Browse other questions tagged or ask your own question.