• vk-kirov (9/9/2010)


    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.

    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.

    Agreed. I have moved the resource database when relocating the master database in SQL Server 2005. I suspected that I'd be marked wrong on this question for selecting the "NONE" option