Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JBPUB
Starting Member
2 Posts |
 Posted - 2008-09-11 : 04:21:23
|
| Hi,I have an error result after using DBCC CHECKTABLE.Serveur : Msg 8966, Niveau 16, État 2, Ligne 1Could not read and latch page (1:1574240) with latch type UP. ?? failed.Serveur : Msg 8966, Niveau 16, État 1, Ligne 1Could not read and latch page (1:1574241) with latch type UP. ?? failed.Serveur : Msg 8966, Niveau 16, État 1, Ligne 1Could not read and latch page (1:1574242) with latch type UP. ?? failed.Serveur : Msg 8966, Niveau 16, État 1, Ligne 1Could not read and latch page (1:1574243) with latch type UP. ?? failed.Serveur : Msg 8966, Niveau 16, État 1, Ligne 1Could not read and latch page (1:1574244) with latch type UP. ?? failed.Serveur : Msg 8966, Niveau 16, État 1, Ligne 1Could not read and latch page (1:1574245) with latch type UP. ?? failed.Serveur : Msg 8966, Niveau 16, État 1, Ligne 1Could not read and latch page (1:1574246) with latch type UP. ?? failed.Serveur : Msg 8966, Niveau 16, État 1, Ligne 1Could not read and latch page (1:1574247) with latch type UP. ?? failed.Serveur : Msg 2533, Niveau 16, État 1, Ligne 1Table error: Page (1:1574240) allocated to object ID 341576255, index ID 255 was not seen. Page may be invalid or have incorrect object ID information in its header.Serveur : Msg 2533, Niveau 16, État 1, Ligne 1Table error: Page (1:1574241) allocated to object ID 341576255, index ID 255 was not seen. Page may be invalid or have incorrect object ID information in its header.Serveur : Msg 2533, Niveau 16, État 1, Ligne 1Table error: Page (1:1574242) allocated to object ID 341576255, index ID 255 was not seen. Page may be invalid or have incorrect object ID information in its header.Serveur : Msg 2533, Niveau 16, État 1, Ligne 1Table error: Page (1:1574243) allocated to object ID 341576255, index ID 255 was not seen. Page may be invalid or have incorrect object ID information in its header.Serveur : Msg 2533, Niveau 16, État 1, Ligne 1Table error: Page (1:1574244) allocated to object ID 341576255, index ID 255 was not seen. Page may be invalid or have incorrect object ID information in its header.Serveur : Msg 2533, Niveau 16, État 1, Ligne 1Table error: Page (1:1574245) allocated to object ID 341576255, index ID 255 was not seen. Page may be invalid or have incorrect object ID information in its header.Serveur : Msg 2533, Niveau 16, État 1, Ligne 1Table error: Page (1:1574246) allocated to object ID 341576255, index ID 255 was not seen. Page may be invalid or have incorrect object ID information in its header.Serveur : Msg 2533, Niveau 16, État 1, Ligne 1Table error: Page (1:1574247) allocated to object ID 341576255, index ID 255 was not seen. Page may be invalid or have incorrect object ID information in its header.CHECKTABLE found 0 allocation errors and 8 consistency errors not associated with any single object.CHECKTABLE found 0 allocation errors and 8 consistency errors in table 'email' (object ID 341576255).repair_allow_data_loss is the minimum repair level for the errors foundIt seems like 8 pages (1extension?) are corrupted for my 2 text columns.I prefere not yet use RESTORE DATABASE.Does repair_allow_data_loss will only delete the rows in this 8 pages ?I used DBCC PAGE but I can not recognise all the rows by read the text values : How can I get the identity of the rows ? I've probably have a disk problem : does I have to do a chdisk /r before or after a repair_allow_data_loss action ?Thanks for your help.Regards,JB. |
|
|
JBPUB
Starting Member
2 Posts |
Posted - 2008-09-11 : 08:57:52
|
| Sorry, but it is quite urgent. Can you help me, please ?Thanks. |
 |
|
|
|
|
|
|
|
DBCC CHECKTABLE ERROR