Had a lovely situation this morning.
I can’t go into details, but essentially a database had no off-site backups, no tape backups and the only full backups were on disk. Then the SAN glitched and both the data files and backups were corrupted.
I’m probably preaching to the converted, but I don’t think there are many more important things on a production server than ensuring good backups.
However, having the backups is not enough. Can they be restored? If there’s a complete drive failure of all drives connected to a server, can the databases be recovered?
When the pawpaw hits the fan (as the local saying goes), that’s the only thing that matters.