Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How do I move mssqlsystemresource to a new location?

Posted on 2009-05-07
5
Medium Priority
?
206 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 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 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

610 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