數據庫報錯, 請問如何處理, 謝謝!

robinhm

數據庫日誌中出現以下錯誤, 請問如何處理? 另外物件id 99為什麼物件, 為何每個數據庫都有, 而且物件id相同, 謝謝
04:00000:00484:2007/04/10 03:00:18.94 server  Error: 695, Severity: 21, State: 1
04:00000:00484:2007/04/10 03:00:18.94 server  An attempt was made to read logical page '14295296' for object '99' in database '4' from disk. Wrong logical page '637941808' was brought into cache 'default data cache'.

xgli1978

dbcc 检查

robinhm

目前只知道select object_name(99) = ALLOCATION,
怎樣dbcc 呀, ALLOCATION好想不是一個表.

hobbylu

ALLOCATION是一个系统表，但是你无法直接select。对于你这个错误，属于非常高级别的错误，需要专业人员进行修复，或者call sybase technolog support.

robinhm

謝謝!

hefan

1 Check the server error log for other errors that may have been raised prior
to the 695 error. Save the entire error log.
2 Obtain page information by running dbcc page as soon as possible, using
the database ID and page number shown in the message:
1> dbcc page (<db_id>, <page_number>, 0, 1, 1, -1)
2> go
3 To determine the scope of the problem, locate the device on which the
database resides, and check if any other databases use the same device.
Refer to “How to Determine Which Physical Devices a Database is On” in
the Encyclopedia of Tasks chapter.
4 Check that the device is partitioned correctly. See “Correct Use of Raw
Partitions” in the Encyclopedia of Tasks chapter .
5 Run dbcc log to find the history of transactions against this page.
6 To determine the full extent of the corruption, run dbcc checkstorage, the
dbcc checkdb and dbcc checkalloc commands, or dbcc checktable and dbcc
tablealloc) as soon as possible.
7 To check if this error is a result of hardware failure, examine your
operating system error log and correct hardware problems. See “Checking
the Operating System Error Log” in the Encyclopedia of Tasks chapter for
assistance. Also see Error 605 for a discussion of potential causes of
hardware error.

按照这个步骤做把。
主要就DBCC的这几条命令的了。

检查设备把。也许要重建呢。。。尽量争取能备份出数据。