You are currently offline, waiting for your internet to reconnect

A SQL Server backup is invalid when the backup is performed on a computer that is configured to use a DPT RAID controller card

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

This article was previously published under Q268481
SYMPTOMS
When you restore backups that were performed through Microsoft SQL Server for databases created on a drive that is running a DPT SmartRAID V controller, the following error message may occur:
Msg 3270, Level 0, Sev 16
An internal consistency error occurred. Contact Technical Support for assistance.
If you detach the database by using the sp_detach_db stored procedure and then try to attach the database by using the sp_attach_db stored procedure, the following error message may occur:
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:\pubs.mdf' is not a valid database file header. The PageAudit property is incorrect.
The same error messages may also occur with other models of the DPT RAID controller card.
CAUSE
This problem occurs from a particular combination of the firmware version on the DPT controller card and the version of the DPT Performance Enhancing driver, Dptdisk.sys.
WORKAROUND
For information about how to correct this problem, follow these steps:
  1. Visit the following Adaptec Web site:
  2. Click Find Answers.
  3. For Search Text, type 2028.
  4. For Search by, select Answer ID.
  5. Click Search.
After updating the driver, you will need to re-create the SQL Server databases. To do this, create a new database for each database that needs to be rebuilt, and then use Data Transformation Services (DTS) to transfer the data to the new databases.

Note You may need to reinstall SQL Server because all of the other databases (including model and msdb) may have the same problem.

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
DPT backup pageaudit sql 7.0
Properties

Article ID: 268481 - Last Review: 12/28/2005 05:46:04 - Revision: 4.3

Microsoft SQL Server 2000 Standard Edition, Microsoft SQL Server 6.5 Standard Edition, Microsoft SQL Server 7.0 Standard Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Express Edition, Microsoft SQL Server 2005 Workgroup Edition

  • kbprb KB268481
Feedback
d=1&t=">='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?">