I lost my database 2 times.
first in 2000 under raid 10. flashed the firmware on the raid card... oops..
at that time I had floppy back ups (3 sets)
all corrupt .
we were able to rebuild the database from a old backup almost completely, had to manually enter 3 months worth of data.
last time was last yr. I had/have.. 2 x raid 6 internal, data backs up to 2nd raid.. plus redundant server with single raid 6,
plus external drobo raid 5, plus external single drive for off site..
we had numerous back ups sadly every one corrupted as my SQL file got corrupt and kept getting worse.. so I was backed up 6 ways to sunday to no avail..
we were able to rebuild the database almost completely, had to manually enter 3 months worth of data.
same as in 2000..
now we check the database integrity constantly.. ::sigh:: another lesson learned! shut us down from order processing for a week..