Location of Master and mssqlsystemresource Databases
Posted on 2011-04-24
I am running several SQL Server 2005 Instances (SP3with CU4) on a Windows 2008R2 Platform.
After I installed the instances I moved the System Databases to a drive other than their original install location and then I must have applied the service packs after I moved the databases so I ended up with 2 sets of the mssqlsystemresource.ldf and mssqlsystemresource.mdf files.
I have since realized that moving the system databases (master, msdb and model) from their original locations is not good practice so I will be moving them back. the model and msdb will not be a problem to move but my dilema lies with the master DB and the 2 sets of mssqlsystemresource.ldf andmssqlsystemresource.mdf files.
Is there a way to tell either by some query or through searching the registry to find out which set of mssqlsystemresource files to keep?
I have one set here \\kocsql05\e$\Microsoft SQL Server\MSSQL.3\MSSQL\Data dated 10\15\2011 (which is the original install directory)
and one set here: \\kocsql05\f$\MSSQL\KOCSQL05\Sharepoint\Datafiles dated 9\26\2009 (which is where I moved the master.mdf file to)
I'm ASSUMING that I should keep the newest mssqlsystemresource files (in the original install location) but I am not sure. any thoughts on how to rectify this and get the master database files back into the original install location with the correct mssqlsystemresource files ????