Backup with checksum

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Backup with checksum

Backup with checksum

Rate Topic

Display Mode

Topic Options

Author

Message

IT researcher

Posted Thursday, January 17, 2013 3:11 AM

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?

Post #1408260

Abu Dina

Posted Thursday, January 17, 2013 3:20 AM

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

Post #1408273

« Prev Topic | Next Topic »

Permissions