Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

How do I move mssqlsystemresource to a new location?

Avatar of recrawfordadmin
recrawfordadmin asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
4 Comments1 Solution283 ViewsLast Modified:
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!