April 25, 2008 at 1:00 pm
Hello, I've been looking at this for two days now and I can't figure it out. I really would appreciate some input.
I have a database that I purposely corrupted on my local machine. In SQL Management Studio, I can confirm that it is corrupted by issuing the command dbcc checkdb() on this database.
However, when I use the Task in SSIS to check the same database, the task just completes without any errors. From what I've read in various forums and articles, this task should fail (turn red in BIDS) if it encounters a corruption. But this is not the behavior I get.
What can I be missing?
If you care to follow this link, it is the same question (with more details) I posted in another forum.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3229581&SiteID=17
April 25, 2008 at 1:12 pm
If you have installed SP2 this could be your issue.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 25, 2008 at 1:32 pm
Jack, Thank you for your quick reply. Indeed, your response helped. I unchecked "Include indexes" option and now the Task fails as expected.
So, In the link you gave me, there are two hotfixes, as follows
** Update: A hotfix is now available to address this issue here for SQL versions 3042 through 3053**
** Update: A hotfix is now available to address this issue here for SQL versions 3150 through 3158**
How do know which one to apply?
April 25, 2008 at 1:47 pm
Run Select @@Version and you get something like this:
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
The bold and underlined portion is what you need to look at.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 25, 2008 at 1:50 pm
Got it. I'm going to apply the hotfix and report back. Thanks again.
April 25, 2008 at 2:22 pm
The hotfix fixed the problem. I can check multiple databases including the indexes and the task properly fails when it finds a corruption. Good stuff....
Thanks again.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply