Topic: 如果sql server database出现了下面的问题，我应该怎么进行下一步的调查？谢谢。 @佛州华人论坛:佛州枫下论坛 The Rolia Forum of Florida

工作学习 / IT技术讨论 / 如果sql server database出现了下面的问题，我应该怎么进行下一步的调查？谢谢。Server: Msg 8928, Level 16, State 1, Line 1
Object ID 293576084, index ID 14: Page (1:1823797) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 293576084, index ID 14, page (1:1823797). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1 -lilyba(sunshine 毁灭者); 2004-10-18 {389} (#1936281@0)

1. run DBCC CHECKDB to verify if the database is corrupt 2. which sp does your server run under? 3. the error may be fixed by running dbcc checkdb with repair_allow_data_loss -yangn(Raymond); 2004-10-18 (#1936295@0)
1. drop and recreate this index. 2. dbcc checkdb, checkindex... 3. reboot server. -whatwhenwherewhy(一生何求); 2004-10-18 (#1936299@0)

谢谢两位。dba问我是否可以修复数据库。她害怕修复数据库，可能会丢失数据。我想知道哪一行数据出的问题。然后她做repair，然后，我再检查一下。这样可以么。我怎么才能知道哪一行呢？ -lilyba(sunshine 毁灭者); 2004-10-18 (#1936310@0)

DBCC CHECKDB 可能会给你出问题的OBJECT ID -yangn(Raymond); 2004-10-18 (#1936327@0)
drop and recreat index may fix the problem, if not, see inside. -whatwhenwherewhy(一生何求); 2004-10-19 {900} (#1937069@0)

thank you man. I just steal some knowledge from Sybase... do not tell Sybase :) -whatwhenwherewhy(一生何求); 2004-10-19 (#1937259@0)

Thanks so much. I will just ask DBA do the job now. I do not have right to do those stuff. It is too dangerous for me too. :P -lilyba(sunshine 毁灭者); 2004-10-19 (#1937547@0)

@Florida