I have virtual machine with SQL Server. SQL Server files and databases are on the same drive. This drive is way too big and I need to make it smaller to save money. My idea was:
- Stop SQL Server.
- Create snapshot of the machine.
- Create new smaller drive.
- Robocopy files (with all attributes, copy, not move) from current drive to new one.
- Remove drive letter from old drive.
- Assign drive letter to new drive.
- Restart SQL Server.
- Remove old, big drive when everything seems to be working fine.
I've done similar scenario with non-SQL drive and it worked fine, but I am afraid something unexpected, related to SQL Server, may stand in the way.
Is this a good plan? What can go wrong?