Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup with checksum Expand / Collapse
Author
Message
Posted Thursday, January 17, 2013 3:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 5:11 AM
Points: 272, Visits: 1,756
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?
Post #1408260
Posted Thursday, January 17, 2013 3:20 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, October 31, 2014 10:27 AM
Points: 708, Visits: 3,293
...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

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
Post #1408273
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse