数据库页面错误,有这方面经验的请进来给点建议,谢谢!
hfyun 2003-02-27 11:37:18 公司的SQL7.0,在程序运行时出错,然后在查询器中执行查询语句时,出现如下错误:
Server: Msg 823, Level 24, State 1, Line 1
I/O error (bad page ID) detected during read of BUF pointer = 0x124c4000, page ptr =
0x22090000, pageid = (0x1:0x137d9), dbid = 7, status = 0x801, file =
F:\MSSQL7.0\data\LYDZ_Data.MDF.
Connection Broken
执行 DBCC Checkdb时,提示:
Server: Msg 2535, Level 16, State 1, Line 0
Table Corrupt: Page (1:81580) is allocated to object ID 23671132, index ID 1, not to object ID -2034142768, index ID 42566 found in page header.
Server: Msg 8909, Level 16, State 1, Line 0
Table Corrupt: Object ID -2034142768, index ID 42566, page ID (1:81580). The PageId in the page header = (21904:-1721538026).
执行完后,会丢失部分数据,但系统可以正常运行。然后过段时间(一两天)问题又重现。
数据只能备份,但在另一台电脑上恢复后问题仍存在。
无法进行数据transfer(import,export)操作。
希望这获得大家的帮助。