Search Knowledge Base
KB #240063: Torn Page or PageAudit Error on DBCC CHECKDB
|When using SQL 2005 on Windows 2003 Server you may receive a Torn Page or PageAudit Error when running the DBCC CHECKDB command.
|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