UMG Developer (9/8/2010)

---

I think it would have been more challenging if it has been multiple choice...

The Resource database is a read-only database that contains all the system objects that are included with SQL Server ... So, the Resource db cannot be moved.

vk-kirov (9/9/2010)

---

Sorry, but this conclusion is wrong. In SQL Server 2005, the Resource database can be moved along with the master database: http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.90).aspx. In SQL Server 2008, the Resource database cannot be moved (as I think) just by design.

Good question, anyway.

In SQL Server 2008, the default location of the Resource database is <drive>:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\Binn\. The database can be moved; however, we recommend against moving it for two reasons:

Applying SQL Server service packs and hotfixes restores the database to the \Binn location.


Moving the Resource database in a failover cluster environment to a nonclustered location will cause failover cluster failure.


To move the Resource database, follow these steps.

Hugo Kornelis (9/9/2010)

---

Good question. Too bad you did not include a reference in the explanation.
For those who want to double check (and to see HOW those system databases can be moved), here is a reference: http://msdn.microsoft.com/en-us/library/ms345408.aspx



True. But it is, unfortunately, not possible to submit a question with only one correct answer as a multiple choice question. The software automatically decides on single choice vs multiple choice based on the number of correct answers.