?
Solved

Troubleshooting the following error

Posted on 2002-03-12
3
Medium Priority
?
169 Views
Last Modified: 2010-07-27
Hi,

I have a maintenance plan scheduled for one database where it does all the
check data and index linkages etc backup fails when i see the maintenance plan
history check data and index linkage fails, i get the following error,i would like to
know the way to trouble shoot this error

Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 2: Errors found in text ID 10027008
 owned by data record identified by RID = (1:24:0) id = 1 and indid = 1.
 

If any body can help me on this,it would be great and helpfull to me

Thanks,
SC
0
Comment
Question by:schinni
  • 2
3 Comments
 
LVL 10

Expert Comment

by:AndresM
ID: 6857171
what version of sql server do you have? (7.0, 2000) what sp?
0
 

Author Comment

by:schinni
ID: 6857259
2000 it's the maintenance plan not sp
0
 
LVL 10

Accepted Solution

by:
AndresM earned 300 total points
ID: 6857441
The error appears in this article, try to see if applies to your problem. The resolution is install SP2.
FIX : DBCC CHECKTABLE May Fail if Corruption Exists in Indexes (Q299323)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q299323
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question