Microsoft KB Archive/268481

= 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

Article Last Modified on 12/28/2005

-

APPLIES TO


 * 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

-



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:  Visit the following Adaptec Web site:

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.

Additional query words: DPT backup pageaudit sql 7.0

Keywords: kbprb KB268481

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.