I have a SQL server running in Hyper-V R2 that has a data VHD that was WAY overallocated when it was made, and now I want to reclaim some of that space.Is performing the VHD safe to do on a drive that is home to SQL DBs?
Obviously the SQL Service needs to be shut down first, but yes I've done it as I've over-allocated myself in the past too.Obviously make sure you back up first.The compression does take some time, and you will want to take a look at this post to maximise the space you reclaim, and keep everything tidy... Hyper-V Size Optimizationr
Post a Comment
2 comments:
I have a SQL server running in Hyper-V R2 that has a data VHD that was WAY overallocated when it was made, and now I want to reclaim some of that space.
Is performing the VHD safe to do on a drive that is home to SQL DBs?
Obviously the SQL Service needs to be shut down first, but yes I've done it as I've over-allocated myself in the past too.
Obviously make sure you back up first.
The compression does take some time, and you will want to take a look at this post to maximise the space you reclaim, and keep everything tidy...
Hyper-V Size Optimization
r
Post a Comment