You can use a tool, such as Sysinternals Process Explorer (Procexp.exe), to determine the location of the
master and
Resource database files that are currently used by the instance of SQL Server 2005.
To obtain Process Explorer, visit the following Sysinternals Web site:
Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.
To determine the location of the
master and
Resource database files in Process Explorer, follow these steps:
- In Process Explorer, locate the
Sqlservr.exe process in the Processpane. - On the View menu, click
Show Lower Pane. - In the lower pane of Process Explorer, make sure that the
Name column is displayed.
If the Name column is not displayed, follow these steps:
- On the View menu, click
Select Columns, and then click the Handle pane. - Click to select the Name check box, and then click OK.
- In the lower pane of Process Explorer, click
Type to sort handles by type. - For the File type items, search the
Name column for the path of the file Mssqlsystemresource.mdf file. This path is the path of the Resource database file. You can also search the Name column for the path of the Master.mdf file. This path is the path of the master database file.
If these paths are different, you must move the database files to the same folder.
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 as the
master database file. Do not put the
Resource database in either compressed or encrypted NTFS file system folders. If you do this, you hinder performance and prevent upgrades.