Damaged allocation pages 是否可以通过导出导入重建库

tolywang

我们的数据库目前报错和下面的类似， 也是 PFS_PAGE page  相关的错误 。
Windows 2003  + SQL Server 2000 SP4 .   


Damaged allocation pages

Msg 8946, Level 16, State 12, Line 1
Table error: Allocation page (1:2264640) has invalid PFS_PAGE page header values. Type is 0. Check type, alloc unit ID and page ID on the page.
Msg 8998, Level 16, State 2, Line 1
Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID 13 pages from (1:2264640) to (1:2272727)

发生这些错误的情况下，数据库的存储映射页已经损坏，这些页是用来标记那些硬盘上那些页和区是已经使用和未使用的，CheckDB是不会修复这些错误的，并且这些错误非常棘手，删除这些页也并不可取，因为每页页都映射着4G的存储数据。



You can search on the string 8946 in Books Online.

As I understand the topic, the only way to repair is restore from a
clean backup. DBCC can repair many problem, but the topic says that if
the error is in an PFS_PAGE it\'s not repairable. (I\'m looking at Books
Online for SQL 2000. 2005 may be different.)