Check, Please

  • Comments posted to this topic are about the item Check, Please

  • This was removed by the editor as SPAM

  • A really interesting question. It gave me a hard time :crazy:, but it was worth it. I learned something new and I got it right 🙂

    It was unnecessary " to have respect" for PowerShell , the answer to these questions is often the topic of MS SQL Server, thank you, Andy.

  • ...It means you have to check the backup before you set the options for the restore. For my revised code & test above you can infer that my backup did have checksum enabled (or it would have failed). ...

    Are you really telling me you still produce backups without using the checksum option ??

    I strongly advise to grab any occasion to detect corruption as soon as possible!

    As of SQL2005 we've been using checksum for all our backups, no matter Dev/QA/Prod.

    It's better to get an alert due to a failed backup, than to have to deal with a corrupted backup file at restore time, when your production database is down or 50devs are out of work.

    btw:

    As of SQLServer 2014 there is a configuration setting which can just set Backup checksum as the default behaviour !

    'backup checksum default'

    ref: Backup checksum default option in SQL Server 2014[/url]

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Deep breath Johan! I'm with you on checksum, I just didn't use it for my tiny test backup when I was scripting. I'm a fan of checksum myself. Did you get the question right?;-)

  • Interesting, thanks for the question Andy!

  • Andy Warren (12/3/2015)


    Deep breath Johan! I'm with you on checksum, I just didn't use it for my tiny test backup when I was scripting. I'm a fan of checksum myself. Did you get the question right?;-)

    No worries, Andy. :w00t:

    Educational moment 🙂

    In my powershell module to restore databases - basically to test our recovery plans - , I have implemented a parameter -NoChecksum to be able to handle backups produced without checksum.

    But we intentionally have it fail because we need to very the source of that backupfile(set).

    Yep, earned myself 3 points today :hehe:

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Interesting question. But I must learn to read more carefully - I read "No Error will be thrown..." as "An eror will be thrown..." so selected that option. No points for me on this one!

    I hope no-one ever uses ReplaceDatabase=true without Checksum=true - using that option without enforcing checksum is usually pure insanity.

    Tom

  • Thanks for the question.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thanks for the question.

Viewing 10 posts - 1 through 10 (of 10 total)

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