September 15, 2009 at 11:15 pm
I have a SQL Database which is in SQL Server 2000 Enterprise SP4 .
Whenever I try to shrink the database I find below error:
"Server: Msg 7105, Level 22, State 6, Line 1
Page (1:713), slot 3 for text, ntext, or image node does not exist.
Connection Broken"
I found that when I run select command on sysindexes table I find the same error.
September 15, 2009 at 11:23 pm
When I perform dbcc checktable on sysindexes table I get below error:
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 3192586240 owned by data record identified by RID = (1:3187:8) id = 1077578877 and indid = 3.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 3192717312 owned by data record identified by RID = (1:3187:10) id = 1077578877 and indid = 5.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 4073455616 owned by data record identified by RID = (1:39184:12) id = 949682531 and indid = 11.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 4073783296 owned by data record identified by RID = (1:39184:17) id = 949682531 and indid = 16.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:713), slot 3, text ID 4073455616 does not match its reference from page (1:3187), slot 8.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 2, text, ntext, or image node page (1:713), slot 3, text ID 4073455616 is pointed to by page (1:3187), slot 8 and by page (1:39184), slot 12.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:713), slot 4, text ID 4073783296 does not match its reference from page (1:395), slot 13.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 2, text, ntext, or image node page (1:713), slot 4, text ID 4073783296 is pointed to by page (1:395), slot 13 and by page (1:39184), slot 17.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3057), slot 10, text ID 3192586240 is not referenced.
DBCC results for 'sysindexes'.
There are 1944 rows in 138 pages for object 'sysindexes'.
CHECKTABLE found 0 allocation errors and 9 consistency errors in table 'sysindexes' (object ID 2).
September 16, 2009 at 1:08 am
First of all if it's not production you can run reindexing on the database.
Than run checktable command if you still have errors you can use repair option to fix the problem but you might have dataloss depending on which repair option are you using.
http://msdn.microsoft.com/en-us/library/ms174338.aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 16, 2009 at 1:23 am
I would check out this link as well.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=75803
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 16, 2009 at 3:17 am
Thanks for the help!!!!
I think I cannot repair sysindexes table as it is a system table. It seems that I need to create a new database and export all tables from existing database to the new one.
September 16, 2009 at 4:15 am
tobin.t
Read this. I am sure you will learn much from this article by Gila.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply