December 2, 2015 at 10:35 pm
Comments posted to this topic are about the item Check, Please
December 2, 2015 at 10:37 pm
This was removed by the editor as SPAM
December 3, 2015 at 7:11 am
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.
December 3, 2015 at 8:11 am
...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
December 3, 2015 at 8:19 am
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?;-)
December 3, 2015 at 8:22 am
Interesting, thanks for the question Andy!
December 3, 2015 at 8:29 am
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
December 4, 2015 at 6:01 am
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
December 7, 2015 at 3:37 am
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
December 7, 2015 at 7:25 am
Thanks for the question.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply