Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My server's G: drive is rapidly running out of space. It mainly contains data files (*.mdf) for both system and user databases. The FullText Catalogs also exist on that drive.

IT added a much lager E: drive.

I would like to:

  • shutdown SQL Server
  • copy everything from G:\ to E:\
  • change the G:\ drive to X:\
  • change the E:\ drive to G:\
  • reboot

Will that cause any problems with SQL Server? At the end of the process all of the files will be on the G:\ drive; just not on the original G:\ drive.

share|improve this question
Which version of SQL Server? Also, why do you need to reboot? – Jon Seigel Aug 8 '12 at 18:09
SQL Server 2005 Enterprise Edition. As for the reboot, I figured it couldn't hurt. – Eli Aug 8 '12 at 18:12
up vote 4 down vote accepted

I just did something like this with my system databases for a SAN migration and it didn't seem to have any negative impact. Having said that, I tested it in a dev/test environment. Do you have an opportunity to test this in a dev/test environment?

Also, there's not much of a need to reboot. Just stop the services, do the move, and start the services.


One final consideration is that you copy the files appropriately. Managing NTFS permissions issues can be a real pain so use something like XCOPY (which is what I used) or RoboCopy to ensure that you preserve the integrity of those permissions.

share|improve this answer
We don't have enough drive/space on the dev server to test. However, this is a standby server for production. The main production server already has a large G:\ drive. Thanks for the permissions tip. I'll use xcopy with /O /X /E /H /K. – Eli Aug 8 '12 at 18:56
Seems to have worked perfectly. Thanks! – Eli Aug 8 '12 at 22:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.