don.schaeffer (1/13/2009)
I'm curious how many people verify their backups. I found that step can take twice as long as performing the backup itself.
I always verify all backups at the SQL Server level, but that doesn't verify against the data, just that the backup is structurally sound. My guy who does the actual Tivoli backups confirmed that he does compares, but it might just be at the computed CRC value. Tivoli is a pretty bloody complex system, he said he'd have to research exactly what a verify consists of to give me a better answer.
Yeah, it could easily double your backup time, though with compressed backups....
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]