Knowledge Base

Search Knowledge Base

KB #240063: Torn Page or PageAudit Error on DBCC CHECKDB

 

Type:

Known Issues
Summary:
When using SQL 2005 on Windows 2003 Server you may receive a Torn Page or PageAudit Error when running the DBCC CHECKDB command.

 

Additional Information:
This is a benign error – i.e., does not cause corruption. SQL 2005 implements the DBCC CHECKDB command slightly differently than SQL 2000, and is not recognizing that a database is encrypted. Other than this, the encrypted database can be used normally.This is a known issue and has been addressed in newer releases of Encryptionizer since Sept 2008

As a workaround, use the DBCC WITH TABLOCK option. This will force SQL to use the SQL 2000 implementation of DBCC which will not result in this problem. E.g.,

   USE northwind
DBCC CHECKDB WTIH TABLOCK
Top