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.
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.