Solved

Troubleshooting the following error

Posted on 2002-03-12
3
166 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 100 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

630 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