0

I need to move my SQL instance to a different drive on the same server but plan to rename the drive to the same drive letter as the original drive the instance was on (after renaming the old drive).

I'm guess I need to stop the SQL service before moving the files, and then start it again.

Are there any other steps needed or precautions I should take?

Note: This instance has databases that are part of synchronous AlwaysOn AGs. Some of the databases are the primary replicas while others are secondary replicas. The primary replica databases are also being moved from the same source and to the same destination drive (as the server instance files).

1

There are the usual precautions such as ensuring up to the minute backups before you start.

Another option you could consider though is to create Mount Points for the new drive so that you don't need to worry about changing drive letters afterwards - the fewer moving parts the better.

2
  • Ok, cool. It sounds like the bulk of the actual process though is just stopping the service, moving the files, and starting the service again?...theoretically there's no issues with doing that? – J.D. Feb 9 '20 at 9:42
  • 2
    As long as they all still have the same path and file level permissions then all should be ok – Martin Cairney Feb 9 '20 at 10:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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