Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • Last Modified:

Troubleshooting the following error

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
schinni
Asked:
schinni
  • 2
1 Solution
 
AndresMCommented:
what version of sql server do you have? (7.0, 2000) what sp?
0
 
schinniAuthor Commented:
2000 it's the maintenance plan not sp
0
 
AndresMCommented:
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now