Checksum resources

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Checksum resources

Postby lculley2011 » Fri May 04, 2012 3:00 pm

For SQL Backup Pro 7.0, how does the checksum check affect resources on the file system in terms of CPU, memory and I/O? Is it worse or better than verifying the header information?
lculley2011
 
Posts: 6
Joined: Thu Dec 08, 2011 8:55 pm

Postby petey » Sat May 05, 2012 2:19 pm

The effect of using the CHECKSUM option is the same as when the option is used on a native SQL Server backup. See this link for some discussion on the performance impact of using this option.

Also, you can use the CHECKSUM option in your backup commands since SQL Backup 4. It wasn't available in the GUI, though.

What do you mean by 'verifying the header information'?
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests

cron