0

I have a windows server that only had 50 GB on the C drive and 4TB on the F drive. I need to exstend the C drive but the only way to do that is by deleting the F drive to reallocate space. If I move data from the F drive to a new drive, delete the F drive, and rename the new drive, will I loss the file path?

Improve this question
1
  • You could instead use a standard naming convention or maybe even mount points on a drive like Z. Then you have Z:\Data\DISK1 instead of the F drive where you store the datafiles in a folder, like Z:\Data\DISK1\sql_dat\myDB.mdf. Either way, you will have to make sure SQL Server has access to the locations as the drive location does not share or have cascading permissions.
    – clifton_h
    May 19, 2019 at 22:52

1 Answer 1

Reset to default
2

If I move data from the F drive to a new drive, delete the F drive, and rename the new drive, will I loss the file path?

If you're going to move everything on F:\ to a new underlying disk and rename that disk F:\ then you should be okay, but you need to ensure all permissions are correctly migrated to avoid issues during restart.

The basic process would be:

  1. Stop SQL Server
  2. Copy all data from F:\ to new drive using robocopy or similar tool that can bring permissions as well.
  3. Remount F:\ as a new drive letter
  4. Remount new disk as F:\
  5. Restart SQL Server and verify health

Reverting should be as simple as reversing the drive letter changes if you run into issues.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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