Select the product you need help with

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

Article ID: 268481 - View products that this article applies to.

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.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

WORKAROUND

For information about how to correct this problem, follow these steps:

Visit the following Adaptec Web site:
http://ask.adaptec.com/cgi-bin/adaptec_tic.cfg/php/enduser/home.php
(http://ask.adaptec.com/cgi-bin/adaptec_tic.cfg/php/enduser/home.php)
Click Find Answers.
For Search Text, type 2028.
For Search by, select Answer ID.
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.

Back to the top | Give Feedback