<div>
(1) &nbsp;If you are using a DPT RAID controller, check this MS article:<br />
<br />
<a href="http://support.microsoft.com/support/kb/articles/Q268/4/81.ASP" rel="ugc nofollow">http://support.microsoft.com/support/kb/articles/Q268/4/81.ASP</a><br />
<br />
(2) &nbsp;What version of SQL Server? &nbsp;MSDE?. &nbsp;If SQL 2000 and MSDE 1.0 / 7.0, then you are out of luck (I think), since the MSDE expects SQL 7 format, and, although SQL 2000 can handle SQL 7 files, I don't believe the reverse is correct.<br />
<br />

</div>


(1)  If you are using a DPT RAID controller, check this MS article:

http://support.microsoft.com/support/kb/articles/Q268/4/81.ASP [http://support.microsoft.com/support/kb/articles/Q268/4/81.ASP]

(2)  What version of SQL Server?  MSDE?.  If SQL 2000 and MSDE 1.0 / 7.0, then you are out of luck (I think), since the MSDE expects SQL 7 format, and, although SQL 2000 can handle SQL 7 files, I don't believe the reverse is correct.



<div>
The tables were created in SQL Server 2000. &nbsp;I'm using MSDE 1.0. &nbsp;I don't know if there's an MSDE version for SQL Server 2000. &nbsp;I thought 1.0 was the only version out there?<br />
<br />
Is this the problem?<br />

</div>


The tables were created in SQL Server 2000.  I'm using MSDE 1.0.  I don't know if there's an MSDE version for SQL Server 2000.  I thought 1.0 was the only version out there?

Is this the problem?


<div>
Thanks bhess1. &nbsp;I'm gonna look for a version for SQL2k or we'll just have to downgrade.<br />
<br />
Thanks again!
</div>


Thanks bhess1.  I'm gonna look for a version for SQL2k or we'll just have to downgrade.

Thanks again!

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I'm trying to attach a db file to an MSDE server.<br />
<br />
The .mdf and .ldf files attach fine to a SQL Server db either run in VB code or done through Query Analyzer.<br />
<br />
When I try to attach the files in VB to MSDE I get the following error:<br />
<br />
Database failed to attach<br />
SQL-DMO error: -2147217900 The header for file 'c:\mssql7\Data\testdb.mdf<wbr />' is not a valid database file header. &nbsp;The PageAudit property is incorrect.<br />
<br />
Does anyone know what the problem is?<br />
<br />
Thanks<br />
<br />
<br />
<br />

</div>
</div>


Hi all,

I'm trying to attach a db file to an MSDE server.

The .mdf and .ldf files attach fine to a SQL Server db either run in VB code or done through Query Analyzer.

When I try to attach the files in VB to MSDE I get the following error:

Database failed to attach
SQL-DMO error: -2147217900 The header for file 'c:\mssql7\Data\testdb.mdf' is not a valid database file header.  The PageAudit property is incorrect.

Does anyone know what the problem is?

Thanks





Not a Valid Database File Header

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.