Add sp_configure option for default backup CHECKSUM behavior - by TiborK

Status : 


Sign in
to vote
ID 317285 Comments
Status Active Workarounds
Type Suggestion Repros 1
Opened 12/13/2007 9:14:04 AM
Access Restriction Public


I believe that many of us agree that doing a backup using CHECKSUM is a best practice. Still, the default is NO_CHECKSUM. 

So, for instance the 98% of installations that uses maint plans (percentage is just a wild guess) do not do the backups using CHECKSUM since this option isn't exposed in a maint plan. 

Sign in to post a comment.
Posted by Microsoft on 4/18/2013 at 7:37 PM
Thanks for reporting this, we'll look at addressing this in a future release.
Posted by Sakthivel Chidambaram on 3/28/2012 at 9:06 PM
We should also consider adding CHECKSUM option to Maintenance plan "BACKUP" task.
Posted by Microsoft on 2/5/2008 at 3:45 PM
Thank you for your suggestion.
This option will not make it into the Katmai feature.
We will consider it for a future release.