I need to move the installation files for SQL Server 2008 R2 from where they currently reside (S:\Program Files...) to a new drive (yet to be created). My S: holds my SQL backups, active data files, and SQL Server program files.
I have only one idea on how to accomplish this:
- Stop all SQL services.
- Create the new drive for the program files with the letter J. (Drive letter doesn't matter.)
- Rename S: to T:.
- Rename J: to S:.
- Move all the program files on T: to S:.
- Start all SQL services.
Unless I am not considering something in this process the SQL Server will not know anything has changed.
If that is a horrible idea about the only other thing I can think of is to create a new server and migrate the databases there.