January 17, 2013 at 3:11 am
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?
January 17, 2013 at 3:20 am
...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!
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply