Scenario
You have a SQL Server VM (VMWare) that has had an unrecoverable disk corruption. It has 250gb of databases on it. The c-drive is the drive that has the corruption. You don't know where the data is for the DBs.
What resources would you have to engage?
What would your steps be to resolve?
How long would it take for you to have a server back online?
Any ideas?
VMwareStorage HardwareStorage
Last Comment
Lobsterguy
8/22/2022 - Mon
bbao
is the VMDK file still accessible using VMware Virtual Disk Manager?
Lobsterguy
ASKER
I forgot to put the following. I'm just the DBA. So engineering handles the VMs and storage handles the storage.
I'd assume I'd need to check that the VMDK file is still accessible. If so then what?
bbao
if the VMDK file is accessible that means that's single file issue (database file) rather than a disk issue (worse, as multiple files maight be affected)
if "corruption" here just means the guest OS is no longer bootable, your DB files might be still in good condition. simply run VMware Virtual Disk Manager to open the VMDK file and copy the DB files to somewhere safe.
Lobsterguy
ASKER
But how would I get the OS to function again? Is there something that can be done with the VMDK files to repair the corruption? Or would I be looking at building a new VM?