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.