Post reply

Full Backup "perform checksum before writing to media"

  • February 10, 2013 at 2:27 am

    #394151

    Hi, Guys.

    i want to ask one thing about full, Differential & Transcriptional backup.

    Can we select the option "perform checksum before writing to media" for these tree type of backups

    please explain.

    regards.

    shafiq

  • February 10, 2013 at 5:07 am

    #1586289

    Yes you can. Each one will run the checksum calculation on the pages before and after they are written to disk to help ensure that what was read from your database is what was written out to backup. It's that simple.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 10, 2013 at 5:41 am

    #1586292

    thanks for your nice response.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply