How do I move mssqlsystemresource to a new location?
Posted on 2009-05-07
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?