Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer

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.

EDIT

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
1  
Seems to have worked perfectly. Thanks! –  Eli Aug 8 '12 at 22:02
add comment

Your Answer

 
discard

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.