Solved

How do I move mssqlsystemresource to a new location?

Posted on 2009-05-07
5
201 Views
Last Modified: 2012-05-06
A previous DBA at my company installed three instances of SQL 2005 on a server. One of the instances is located on a local drive (D) and the other two were put on a NAS drive (G). Since the databases on the G drive were very small, I wanted to move them to the local drive to make better use of my SAN. I was able to move all of the system databases and user databases to the D drive with no problem. However, for both instances that were on the G drive, I still have mssqlsystemresource.mdf and mssqlsystemresource.ldf stuck on there. I made a backup of these files and tried to delete the original from the G drive but they were in use, still, by SQL Server. I was able to delete them after stopping all SQL Server services, but they wouldn't restart after. So, I copied my backup over and got everything working again.

My question: How can I move these files off of my G drive and onto my local D drive?

Many thanks!
0
Comment
Question by:recrawfordadmin
5 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24324983
0
 
LVL 1

Expert Comment

by:Kanchipuramdeena
ID: 24325139
0
 

Author Comment

by:recrawfordadmin
ID: 24326179
Neither of your suggestions were helpful. I'm still not having any luck whatsoever getting these files moved. Can anyone offer another suggestion?
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 25509998
short answer: you cannot.
the file MUST be located as indicated:
Physical Properties of Resource 
The physical file names of the Resource database are mssqlsystemresource.mdf and mssqlsystemresource.ldf. These files are located in <drive>:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\MSSQL\Binn\.

Open in new window

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question