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.
Hello,
Welcome to the Voice of the DBA, my blog and site on experiences working with data and databases across three decades.
administration AI Azure Backup/Recovery career career2 car update Cloud Computing coping database design databases Database Weekly DevOps disaster recovery encryption Friday Poll goals hardware Humor life Microsoft misc PASS powershell Redgate republish sabbatical security software development software development speaking SQL in the City SQLNewBlogger SQL Prompt SQL Saturday sql server syndicated T-SQL T-SQL Tuesday Tesla travel vacation windows words work
Voice of the DBA 
One response to “Verify those Backups”
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