July 4, 2011 at 4:16 am
Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (1:249632) with latch type UP. ϴㇶ failed.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 510624862, index ID 5. Page (1:226638) is missing a reference from previous page (1:249632). Possible chain linkage problem.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:249632) allocated to object ID 510624862, index ID 5 was not seen. Page may be invalid or have incorrect object ID information in its header.
HI,
This weekend i received a mesaage from one college reporting taht he can't make backups of a database.
I asked him to make a DBCC checkdb with no_infomsgs, witch returned this result:
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 510624862, index ID 5. Page (1:249632) was not seen in the scan although its parent (1:226614) and previous (1:147447) refer to it. Check any previous errors.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'CONTRIBUINTESEST' (object ID 510624862).
CHECKDB found 0 allocation errors and 4 consistency errors in database 'sgct'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (sgct ).
Can someone help?
Thank you
P.S i was thinking in doing a Rebuild of all database indexes, what do you think?
July 4, 2011 at 5:02 am
#1 make sure you take an extra backup before doing anything.
#2 rebuild ONLY that 1 index.
Since the problem is in a nonclustered index you should be able to drop it and rebuild without any data loss.
#3 Find out what is corrupted in the disks (it's the source of corruption 99.9% of the time).
You can get the name of the index with this query :
This is the sql 2000 version since we're on sql 2000 forum.
SELECT name, * FROM dbo.sysindexes where id = 510624862 and indid = 5
July 4, 2011 at 5:09 am
I can not make backups has mentioned.
People are not working, is there a problem in rebuilding all the indexes instead of just one?
thanks.
July 4, 2011 at 5:18 am
river1 (7/4/2011)
I can not make backups has mentioned.People are not working, is there a problem in rebuilding all the indexes instead of just one?
thanks.
Much longer and might break something else if the disk is damaged somewhere else.
Try with just the one and rerun checkdb WITHOUT allow_repair to see where you're at.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply