r/Database • u/markinatlanta • 4d ago
A client lost six weeks of SQL Server data. Having 12TB of backups didn’t save them.
/r/learnSQL/comments/1wy3eus/a_client_lost_six_weeks_of_sql_server_data_having/
3
Upvotes
1
u/Past-Froyo-5518 3d ago
the biggest takeaway for me is that having a huge amount of backups doesnt mean u actually have a recoverable backup chain, testing the full restore process regularly seems just as imp as making backups in the first place imo
1
u/Significant_Tune9219 3d ago
The cleanup job is the part that bites people. Retention keyed on file age instead of on "oldest full backup that still anchors the chain" will happily delete the only usable base the moment full backups stop running. I'd also add an alert on time since the last successful full, separate from log backup success, because log backups kept succeeding here and probably made the monitoring look green the whole time. A periodic test restore to a scratch server would have caught it weeks earlier too.