|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 183,
Visits: 948
|
|
The sql server has an option for checking checksum after creating backup(WITH CHECKSUM).
I want to know whether sql server needs extra time to backup with checksum than the normal backup? Does it is godd to use or not?
|
|
|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Today @ 11:55 AM
Points: 494,
Visits: 2,149
|
|
...from BOL
CHECKSUM Specifies that the backup operation will verify each page for checksum and torn page, if enabled and available, and generate a checksum for the entire backup. This is the default behavior for a compressed backup.
Using backup checksums may affect workload and backup throughput.
I use it in my backup sproc.. but I still do weekly restores of a random set of databases. Everyone here recommends doing regular restores. I read this advice so much I got the hint eventually and scheduled a weekly task to do this kind of thing on fridays!
----------------------------------- http://www.SQL4n00bs.com
|
|
|
|