Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Troubleshooting the following error

Posted on 2002-03-12
3
Medium Priority
?
167 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 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

664 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