Skip to main content
edited tags
Link
Eli
  • 480
  • 5
  • 9
Source Link
Eli
  • 480
  • 5
  • 9

Can I move data and full text search files to another drive and change the drive letter?

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.