In a post on SqlServerCentral.com, it is mentioned by several people that the files for the Resource database (mssqlsystemresource.mdf and ldf) should be placed in the same folder as the master database file. This was for SQL Server 2005. Is this still a recommendation when it comes to SQL Server 2017? I tried looking in BOL, but could not find any mention of this there.
Sql-server – SQL Server placement of master database files vs resource database files
sql serversql-server-2017
Related Question
- Sql-server – Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery
- Sql-server – Is is possible to recover a database from the ‘raw’ files (.mdf and .ldf) of the old server to a new SQL Server instance on a new server
- Sql-server – On SQL Server 2017 (Linux), where is the Resource Database persisted (located on disk)
- Sql-server – Best practices for SQL Server block size while formatting disks for data and log files
- Sql-server – Databases missing after exporting server and rebuilding master DB
Best Answer
Totally agree with what George has mentioned, just trying to shed some more light to make it clear.
For SQL Server 2005
You were allowed to move resource database. If you read SQL Server 2005 Master Database Document it says
But this caused problem during service pack upgrade when users started moving it along with master database. The issue came while applying SP/CU which eventually failed because resource database was moved.
For SQL Server 2008 and above.
This was then fixed by MS and they changed the whole thing such that "user is not allowed to change resource database location" and this is why it was moved to
<drive>:\Program Files\Microsoft SQL Server\MSSQL<version>.<instance_name>\MSSQL\Binn
folder along with other binaries, people normally do not touch contents of BINN folder. It's specifically in BINN folder because it does not contains any USER data only information related to SQL Server.Yes there was some discrepancy in BOL documents which was later fixed. I wrote an article on this please read Should We Move Resource Database
Moral: Do not move resource database