InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 08:14:41 GMT20http://www.sqlservercentral.com/Forums/Topic1408260-391-1.aspx...from BOLCHECKSUMSpecifies 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. [b]Using backup checksums may affect workload and backup throughput. [/b]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!Thu, 17 Jan 2013 03:20:24 GMTAbu Dinahttp://www.sqlservercentral.com/Forums/Topic1408260-391-1.aspxThe 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?Thu, 17 Jan 2013 03:11:01 GMT IT researcher