I've been tasked with creating a backup routine for our data warehouse.
This is the situation at the moment:
Before taking the backups I check for corruption with DBCC CHECKDB. After the backup I use RESTORE VERIFY ONLY with the CHECKSUM option to check the backups validity. Due to certain constraints though, I then have to copy our backups across our network to another servers disk.
My worry is that copying the files over may cause corruption to the backup files during the disk I/O operations and I am not checking for this.
Does anyone know A) if this is a real danger? B) how likely it is?
I'm guessing the need to copy backups between storage devices is not uncommon, but do you risk corrupting the files and hence should you always be checking the validity of the backups after each copy?
"Measure twice, saw once"