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


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 7.0
  • 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
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:

    http://ask.adaptec.com/cgi-bin/adaptec_tic.cfg/php/enduser/home.php

  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.
Modification Type:MajorLast Reviewed:12/28/2005
Keywords:kbprb KB268481 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.