Example scenario based on the kinds of failures we see. Not an individual client result.
Dell server running VMware: a failed RAID 10 mirror
Both drives in one mirrored pair of a RAID 10 array fail, one quietly days before the other. Forcing a drive back online in the RAID controller BIOS corrupts the VMware datastore, and the virtual machines disappear.
How we handle it: We connect every SAS drive to write-blocked equipment and image the failing drive in several targeted passes. Then we rebuild the RAID 10 mirrors virtually, repair the VMFS datastore, and extract the virtual machine (.VMDK) files, including SQL databases, for verification.
Lesson: Forcing an offline drive back online through the controller can overwrite good data with stale data. Image first.