各位大哥，救救我；数据恢复失败，错误提示..

[澫大醉]

用的是sql7.0 win98系统

数据恢复时出现以下的提示：


error 823:I/O error(bad page ID) detected during read of BUF
pointer=0x11719000,page ptr=0x12490000,pageid=(0x1:0x269a),dbid=8,
status=0x801,file=D:\数据库中心\cdm405_data.mdf.

[huazf]

可以找我
QQ:386999
Tel:[phone]

[markingqin]

这个问题我也碰到过呀楼上能不能和我讲一下这是什么引起的

[cgsun]

不知道備份地時候驗證一下備份文件可否避免發生類似情況

[澫大醉]

谢谢楼上的两位大哥！

那是三号的事情了，幸好两个月前的一个备份能恢复，最近几个月的数据都是靠人补的，没办法；网上有人找过我，说发过去，看一下；我问了一下领导，说价钱太贵，就没......
原因是这样的：
数据是公司的开票员给备份的，听她说是拷贝cdm405_data.mdf和cdm405_log.ldf到E盘时死过一次机，因主板不好，以前也出现过这样的事，那时没出现过恢复不了的情况，电脑有点旧，数据太大，备份一次要好长时间，也就没太在意；拷完后就叫电脑公司的人换了块主板，格了硬盘，重装系统了，所以就.....

操作的提示如下：


1，用查询分析器，执行附加如下：

exec sp_attach_db @dbname='cdm405',
@filename1='d:\data\cdm405_data.mdf',
@filename2='d:\data\cdm405_log.ldf'

成功附加的提示：Successfully attached database 'cdm405'.

2.在查询分析器执行以下语句：
USE master
EXEC sp_dboption 'cdm405', 'single user', 'true'
DBCC CHECKDB ('cdm405', REPAIR_ALLOW_DATA_LOSS )
EXEC sp_dboption 'cdm405', 'single user', 'false'

提示如下：

[澫大醉]

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The database is now single user.
Server: Msg 8966, Level 16, State 5, Line 31536964
Could not read and latch page (1:16176) with latch type SH. PFS failed.
Server: Msg 2535, Level 16, State 1, Line 31536964
Table Corrupt: Page (1:9784) is allocated to object ID 2, index ID 255, not to object ID -2122259387, index ID 6278 found in page header.
Server: Msg 8909, Level 16, State 1, Line 31536964
Table Corrupt: Object ID -2122259387, index ID 6278, page ID (1:9784). The PageId in the page header = (24118:1184481936).
Server: Msg 2535, Level 16, State 1, Line 31536964
Table Corrupt: Page (1:9779) is allocated to object ID 2, index ID 255, not to object ID -2071768958, index ID 31659 found in page header.
Server: Msg 8909, Level 16, State 1, Line 31536964
Table Corrupt: Object ID -2071768958, index ID 31659, page ID (1:9779). The PageId in the page header = (39584:-976580588).
Server: Msg 2535, Level 16, State 1, Line 31536964
Table Corrupt: Page (1:9979) is allocated to object ID 2, index ID 255, not to object ID -2003775641, index ID 9868 found in page header.
Server: Msg 8909, Level 16, State 1, Line 31536964
Table Corrupt: Object ID -2003775641, index ID 9868, page ID (1:9979). The PageId in the page header = (15967:-838859695).
Server: Msg 2535, Level 16, State 1, Line 31536964
Table Corrupt: Page (1:9978) is allocated to object ID 2, index ID 255, not to object ID -1974649742, index ID 7611 found in page header.
Server: Msg 8909, Level 16, State 1, Line 31536964
Table Corrupt: Object ID -1974649742, index ID 7611, page ID (1:9978). The PageId in the page header = (44098:-67374983).
Server: Msg 2535, Level 16, State 1, Line 31536964
Table Corrupt: Page (1:9827) is allocated to object ID 2, index ID 255, not to object ID -1962124732, index ID 10568 found in page header.
Server: Msg 8909, Level 16, State 1, Line 31536964
Table Corrupt: Object ID -1962124732, index ID 10568, page ID (1:9827). The PageId in the page header = (15353:1311393411).
Server: Msg 2535, Level 16, State 1, Line 31536964
Table Corrupt: Page (1:9982) is allocated to object ID 2, index ID 255, not to object ID -1943156906, index ID 43823 found in page header.
Server: Msg 8909, Level 16, State 1, Line 31536964
Table Corrupt: Object ID -1943156906, index ID 43823, page ID (1:9982). The PageId in the page header = (64253:-630551568).
Server: Msg 2535, Level 16, State 1, Line 31536964

[澫大醉]

1892556647, index ID 27006 found in page header.
Server: Msg 8909, Level 16, State 1, Line 3
Table Corrupt: Object ID 1892556647, index ID 27006, page ID (1:9928). The PageId in the page header = (42240:136738490).
Server: Msg 8909, Level 16, State 1, Line 3
Table Corrupt: Object ID 1917909604, index ID 44075, page ID (1:56616). The PageId in the page header = (8937:327756405).
Server: Msg 2535, Level 16, State 1, Line 3
Table Corrupt: Page (1:9884) is allocated to object ID 2, index ID 255, not to object ID 1938236312, index ID 29779 found in page header.
Server: Msg 8909, Level 16, State 1, Line 3
Table Corrupt: Object ID 1938236312, index ID 29779, page ID (1:9884). The PageId in the page header = (5007:-595385067).
The repair level on the DBCC statement caused this repair to be bypassed.
CHECKDB found 0 allocation errors and 2 consistency errors in table '(Object ID 1879123122)' (object ID 1879123122).
The repair level on the DBCC statement caused this repair to be bypassed.
The repair level on the DBCC statement caused this repair to be bypassed.
CHECKDB found 0 allocation errors and 2 consistency errors in table '(Object ID 1892556647)' (object ID 1892556647).
The system cannot self repair this error.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1917909604)' (object ID 1917909604).
The repair level on the DBCC statement caused this repair to be bypassed.
中间有一些省了，太多发不下


The repair level on the DBCC statement caused this repair to be bypassed.
CHECKDB found 0 allocation errors and 2 consistency errors in table '(Object ID 1938236312)' (object ID 1938236312).
CHECKDB found 3 allocation errors and 266 consistency errors in database 'cdm405'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The database is now multiuser.