• dharmendra.keshari (11/8/2012)


    Hi Paul,

    Thank you so much for writing on CheckSum. it is really awesome blog.

    Could you please provide any link which gives us information about the all the activities which happen internally when we perform backup with option "Perform checksum before writing to media" ?

    Thanks!

    Dharmendra Keshari

    Dharmendra.Keshari@gmail.com

    Thanks!

    There isn't one that goes into internal details. The pertinent facts are that the checksums of allocated pages in the database are validated before being written to the backup - that's all we care about.

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005