July 21, 2009 at 1:51 am
iam a dba in a large government institution in a database with sql2000 a problem,
when i make a dbcc checkdb ,REPAIR_ALLOW_DATA_LOSS
i recieve these results
Object ID 2: Errors found in text ID 124886646784 owned by data record identified by RID = (1:262872:0) id = 1353472296 and indid = 9.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 124886712320 owned by data record identified by RID = (1:262872:1) id = 1353472296 and indid = 10.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 124886777856 owned by data record identified by RID = (1:262872:2) id = 1353472296 and indid = 11.
the id = 1353472296 is a table when i tried to drop it , i recieve this result:
Server: Msg 7105, Level 22, State 6, Line 1
Page (1:74480), slot 0 for text, ntext, or image node does not exist.
Connection Broken
Please help me quickly
July 21, 2009 at 1:57 am
Can you run the following and post the full results?
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 2:07 am
this is the result of DBCC CHECKDB (dbname) WITH NO_INFOMSGS, ALL_ERRORMSGS:
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 124886646784 owned by data record identified by RID = (1:262872:0) id = 1353472296 and indid = 9.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 124886712320 owned by data record identified by RID = (1:262872:1) id = 1353472296 and indid = 10.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 124886777856 owned by data record identified by RID = (1:262872:2) id = 1353472296 and indid = 11.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:73784), slot 0, text ID 124886646784 is not referenced.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:74480), slot 0, text ID 124886646784 is referenced by page (1:262872), slot 0, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:74480), slot 4, text ID 124886712320 is referenced by page (1:262872), slot 1, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
July 21, 2009 at 2:55 am
CheckDB won't repair these, they're damaged statsblobs in sysindexes. There's a chance that we can repair them manually, if it doesn't work, you're going to have to either restore from a clean backup or recreate the database.
Please run this and post the results:
SELECT object_name(id) as TableName, indid, name, INDEXPROPERTY(id, name, 'IsStatistics') AS IsStats
from sysindexes
where id = 1353472296 and indid in (9,10,11)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 21, 2009 at 7:18 am
Edit: Nevermind, the post above (and the one below) is spam.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply