November 19, 2003 at 7:49 am
I am Getting the error 7105
Page %S_PGID, slot %d for text, ntext, or image node does not exist.
Who Can It Be Repaired
DBCC CHECKDB ('DB NAME',REPAIR_REBUILD)
Does Not Work
November 19, 2003 at 8:10 am
Sounds like you got some corruption.
If dbcc checkdb is stuck before you get any better ideas what I have in mind would be to create a new
database, then use DTS to copy out all the objects and data.
Mike
November 19, 2003 at 9:52 am
try a select * from the table and see if you get all rows. Also try rebuild a clustered index or change the clustered index to another column. That will force a data movement. If you've lost a text/image page somewhere I think you will need to call PSS to get some help.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 19, 2003 at 10:00 am
I would run dbcc checkdb without parameter to see which tables have allocation and structural errors and go from there.
November 20, 2003 at 12:17 am
First Thanks For The Advice
the error returend from The DBCC DBREPAIR
Are
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 17397841920 owned by data record identified by RID = (1:16680:6) id = 174623665 and indid = 10.
AND THE PROBLEM Is In Sysindexes
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:248) allocated to object ID 2, index ID 255 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:248), slot 1, text ID 17397841920 is referenced by page (1:16680), slot 6, but was not seen in the scan.
Does Not have A Choice And I am Consider my self lucky Because The Backup Restored OK
No data loss
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply