Hello,
I've run into an interesting situation with a customer. We will be moving
the system databases from one drive to another. I've done this before without
any issues. My concern is the following paragraph, found in the
http://msdn.microsoft.com/en-us/library/ms190940(SQL.90).aspx MSDN article:
"The Resource database depends on the location of the master database. If
you move the master database, you must also move the Resource database to the
same location. For more information, see Moving System Databases. Also, do
not put the Resource database in either compressed or encrypted NTFS file
system folders. Doing so will hinder performance and prevent upgrades."
I've read many other documents that support this paragraph when running SQL
2005, however this information is new to me. I've moved the system databases
before, without moving resource. I know for a fact we have customers out
there who's master databases reside on separate drives from the resource
database location.
What I need to know is, why does the resource database depend on the
location of the master database, and what are the implications of it residing
in a different location? The fact that a SQL 2005 instance will start does
not preclude the fact that something will break down the road.
