Solved

How do I move mssqlsystemresource to a new location?

Posted on 2009-05-07
5
203 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 143

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

730 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