Ninja's_RGR'us (12/12/2012)

---

There's only 1 valid test.

FULL restore, including diffs and logs.

THEN run checkDB.


Now you know you're good.

Once that's done you can't move the files because they could get corrupted in the transfer. Of course it could still happen sittin on the disk. So yes, if you can, retest old backups every once in a while.

raotor (12/12/2012)

---

Granted.

But, if you can't actually restore, then what's the next best thing?

BACKUP DATABASE test
TO DISK = 'd:\test_checksum.bak'
WITH CHECKSUM, INIT;

RESTORE VERIFYONLY 
From disk = 'd:\test_checksum.bak'
WITH CHECKSUM