text, ntext or image error

Last Post 02 Mar 2011 06:15 PM by rm. 30 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Page 2 of 2 << < 12
Author Messages Not Resolved
gunneyk
New Member
New Member

--
15 Feb 2011 08:15 AM
Were you able to get the single_user in the first place? What does sp_who2 show for that SPID?
dstpaul
New Member
New Member

--
15 Feb 2011 09:35 AM
I ran it again - this is the top info - the rest of the db checked out

Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 3340726566912 owned by data record identified by RID = (1:6282:2) id = 466100701 and indid = 6.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 3340322668544 owned by data record identified by RID = (1:6638:1) id = 302272482 and indid = 1.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2974986), slot 7, text ID 3340726566912 does not match its reference from page (1:6638), slot 1.
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:2974986), slot 7, text ID 3340726566912 is pointed to by page (1:6638), slot 1 and by page (1:6282), slot 2.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:5054961), slot 17, text ID 3340322668544 is not referenced.
DBCC results for 'play'.
DBCC results for 'sysobjects'.
There are 15096 rows in 333 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
The repair level on the DBCC statement caused this repair to be bypassed.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be bypassed.
The repair level on the DBCC statement caused this repair to be bypassed.
The repair level on the DBCC statement caused this repair to be bypassed.
There are 6613 rows in 982 pages for object 'sysindexes'.
CHECKDB found 0 allocation errors and 5 consistency errors in table 'sysindexes' (object ID 2).
gunneyk
New Member
New Member

--
15 Feb 2011 12:50 PM
Well it looks like you will just have to lose some data to fix it. It looks like just a few pages so that is good but you will have to run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS. Then make sure you ahve regular good backups and run checkdb on a regular basis as well.
Dunbar
New Member
New Member

--
16 Feb 2011 01:39 PM
this is the result of dbcc checkdb allow data loss - it says it is bypassing repair on some objects - do you think I should bring in a sql expert
gunneyk
New Member
New Member

--
16 Feb 2011 02:58 PM
At this point it looks like your only option is to create another database and copy all the data from this one to the new one. You may lose some data but at least you will have a non-corrupt database again. It looks like the corruption may be contained to sytem tables which if true means you wont actually lose any data.
Dunbar
New Member
New Member

--
17 Feb 2011 05:55 AM
what's the best way to copy the data
gunneyk
New Member
New Member

--
17 Feb 2011 06:16 AM
Create the new database by scripting the existing db and all the objects. YOu might want to leave the indexes off until after you load the tables. Then use either the Import / Export wizard or BCP to export and import the data. It's more a matter of which way you are most comfortable with.
Dunbar
New Member
New Member

--
24 Feb 2011 07:07 AM
is there an easy way to do this - I tried scripting via the DB thru the SQL utilities but it doesn't work. Or, is there some documentation on the procedure - thanks
rm
New Member
New Member

--
24 Feb 2011 09:22 AM
Right click on the db in ssms then go to tasks -> generate scripts.
Dunbar
New Member
New Member

--
02 Mar 2011 12:38 PM
I narrowed it down to a PK index on a table - the whole table has 8 entries - is there a way to reindex this
rm
New Member
New Member

--
02 Mar 2011 06:15 PM
Use 'alter index inx_name on tab_name rebuild'.
You are not authorized to post a reply.
Page 2 of 2 << < 12


Acceptable Use Policy