It’s important that you backup your database. The most important thing you can do. However making backups isn’t enough: you need to verify those backups are good.
A humorous short video from Grant Fritchey (b | t) and RedGate on why:
Ideally you verify every backup every day, but that’s not always feasible. At least make sure you’re doing one backup from every database at least once a month.


I kinda touched this topic (backup verification using the RedGate tool) in a post: http://marlonribunal.com/your-sql-server-database-just-failed-can-you-restore-the-backup/
LikeLike