Converted SQL 2008 R2 Sp1 to Hyper-V long ago but now RAID 5 is failing
Some time ago I converted a standalone SQL 2008 R2 server to VHD and put on Hyper-V. It has been running fine. Space got low on data drive and I checked and noticed that one of my 3 virtual disks was missing, has a red x on it. The other 2 showed failed redundancy. I am not sure how to fix this on a VM. Would I be better off trying to export and import databases to another SQL 2008 instance?
ASKER
The software RAID was a leftover from when the server was a standalone machine. The VHD converter just replicated the entire hard drive setup, and admittedly as my first hardware to VM conversion, I did not try to change it at that time.
In any case, now it needs attention. I assume you mean to use the Windows Backup manager. Backup the OS as one file, then the data drives as one file, then import them into two different VHDX disks. Does that sound right?
In any case, now it needs attention. I assume you mean to use the Windows Backup manager. Backup the OS as one file, then the data drives as one file, then import them into two different VHDX disks. Does that sound right?
What backup product is being used to back up either the entire host or the guest VM?
ASKER
Right now we replicate to a second server. VMs are shutdown, copied to external drive and taken offsite on regular basis. No backup software involved.
Ouch. :(
That's not really the best way to do it.
Veeam or ShadowProtect are very reasonable in cost and provide excellent recovery options as well as off-site streaming if need-be.
We've had enough all-out disasters in our years in this business to know that a proper backup and restore process _must be in place.
That's not really the best way to do it.
Veeam or ShadowProtect are very reasonable in cost and provide excellent recovery options as well as off-site streaming if need-be.
We've had enough all-out disasters in our years in this business to know that a proper backup and restore process _must be in place.
ASKER
Preaching to the choir friend. We are a state agency and they won't cough up the money for recovery software so I do what I can with what I have.
Back to the question at hand though. Can I back up the OS as one file, then the data drives as one file, then import them into two different VHDX disks?
Back to the question at hand though. Can I back up the OS as one file, then the data drives as one file, then import them into two different VHDX disks?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, looks like that will solve my problem.
ASKER
Thanks, I will use Veam to fix it.
Back up the VM, delete it, then restore it to a newly created VM using a single VHDX file for the OS and a single VHDX file for data partition.