<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Jesse Reich
»
Catching errors in DBCC CHECKDB
19 posts, Page 1 of 2
1
2
»»
Catching errors in DBCC CHECKDB
Rate Topic
Display Mode
Topic Options
Author
Message
Jesse Reich
Jesse Reich
Posted Tuesday, November 03, 2009 11:07 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, June 04, 2013 12:26 AM
Points: 164,
Visits: 895
Comments posted to this topic are about the item
Catching errors in DBCC CHECKDB
Post #813427
ChiragNS
ChiragNS
Posted Wednesday, November 04, 2009 1:06 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365,
Visits: 1,825
learnt something new.
"Keep Trying"
Post #813462
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Wednesday, November 04, 2009 2:42 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 3,164,
Visits: 4,344
very interesting....
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #813494
Steve Vassallo
Steve Vassallo
Posted Wednesday, November 04, 2009 8:38 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, May 02, 2013 12:25 PM
Points: 525,
Visits: 215
Learned something today... Good question and keep them coming.
Post #813634
GabyYYZ
GabyYYZ
Posted Wednesday, November 04, 2009 9:57 AM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 1:00 PM
Points: 802,
Visits: 2,013
Wouldn't the backup fail because of a corrupt table?
Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein
Post #813701
Jesse Reich
Jesse Reich
Posted Wednesday, November 04, 2009 3:26 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, June 04, 2013 12:26 AM
Points: 164,
Visits: 895
I actually tested the script out before I submitted it and the backup will happen. I used a corrupted database as the sample.
Post #813906
Ol'SureHand
Ol'SureHand
Posted Wednesday, November 04, 2009 10:26 PM
Old Hand
Group: General Forum Members
Last Login: Monday, June 10, 2013 1:35 AM
Points: 357,
Visits: 706
IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).
That is because the BACKUP command comes AFTER the END CATCH ....
What is the purpose of the TRY/CATCH block if not to avoid crashing an execution sequence?
Post #814004
Ol'SureHand
Ol'SureHand
Posted Wednesday, November 04, 2009 10:28 PM
Old Hand
Group: General Forum Members
Last Login: Monday, June 10, 2013 1:35 AM
Points: 357,
Visits: 706
IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).
That is because the BACKUP command comes AFTER the END CATCH ....
What is the purpose of the TRY/CATCH block if not to avoid crashing an execution sequence?
Post #814006
Ol'SureHand
Ol'SureHand
Posted Wednesday, November 04, 2009 10:30 PM
Old Hand
Group: General Forum Members
Last Login: Monday, June 10, 2013 1:35 AM
Points: 357,
Visits: 706
IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).
That is because the BACKUP command comes AFTER the END CATCH ....
What is the purpose of the TRY/CATCH block if not to avoid crashing an execution sequence?
Post #814007
Ol'SureHand
Ol'SureHand
Posted Wednesday, November 04, 2009 10:43 PM
Old Hand
Group: General Forum Members
Last Login: Monday, June 10, 2013 1:35 AM
Points: 357,
Visits: 706
IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).
That is because the BACKUP command comes AFTER the END CATCH ....
What is the purpose of the TRY/CATCH block if not to avoid crashing an execution sequence?
Post #814012
« Prev Topic
|
Next Topic »
19 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
