question

Pete1 avatar image
Pete1 asked

In a SQL 2008 R2 SP2 cluster, does mssqlresouce database need to be in same location as master database (on shared storage)?

Please could you help. I have created a 2 node, SQL Server Standard 2008 R2 SP2 x64 active-passive cluster. Disk configuration is as follows: C Local drive on each node Windows 2008 R2 Enterprise 64 bit; E Shared storage Tempdb; F Shared storage Indexes; G Shared storage Databases; H Shared storage Logs; I Shared storage Quorum; J Shared storage MSDTC; The master, model and MSDB databases are on the G shared storage drive. However, the mssqlsystemresource database has been installed in C:\ Program Files \Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn . Is this OK or does it need to be in same location as master ? Will it be OK now, but as soon as I apply any SQL patches or fail over, I could be in trouble? Thanks in advance.
sql-server-2008-r2clustersystem-databases
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Shawn_Melton avatar image
Shawn_Melton answered
As stated by Microsoft [here][1]: > The location of the Resource database is :\\Program Files\\Microsoft SQL Server\\MSSQL11.\\MSSQL\\Binn\\. The database cannot be moved. [1]: http://technet.microsoft.com/en-us/library/ms345408.aspx#Resource
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pete1 avatar image
Pete1 answered
OK thanks. It looks like on the install part for Database Engine Configuration, if you change “Data root directory” to shared storage, the mssqlsystemresource will still go to the previously specified program locations (like local C), so I will leave there. Having looked into this a bit more, I have found some people have had to move it because of failures during applying service packs, but it looks like its best to avoid moving.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.