Grant Fritchey provides an important public service announcement:
Please, let me reiterate: The only valid test of a backup is a restore.
THE
ONLY
VALID
TEST
OF
A
BACKUP
IS
A
RESTORE.
Grant is absolutely correct here. And do you know how hard it is to test a SQL Server backup? With dbatools, it’s this hard: Test-DbaLastBackup. That one cmdlet restores a backup (under a different name so it doesn’t clobber your existing database), runs DBCC CHECKDB against the restored data, drops the test database after the fact, and even allows you to do all of that against a different SQL Server instance.
Incidentally, my next YouTube series just happens to be around backup and restoration in SQL Server, so stay tuned if you’re interested.
Leave a Comment