April 30, 2004 at 3:52 am
I have been trying to attach a database i earlier detached from sql server 2000 to msde but to no avail.
It gave the following error message:
Msg 5172, level 16, State 15, Server<Servername>, Procedure, Line 1 [Microsoft][ODBC SQL Server Driver][SQL Server] The header for the '<filepath>\filename.mdf' is not a valid database file header. The PageAudit property is incorrect
Please help.
April 30, 2004 at 4:30 am
See if this applies to your situation.
http://support.microsoft.com/default.aspx?scid=kb;en-us;268481
/Kenneth
April 30, 2004 at 4:31 am
Article PSS ID Number: 268481 discribes the same error. Check it out.
April 30, 2004 at 4:35 am
Thanks I'll look it up
April 30, 2004 at 9:58 am
I looked up the article. It didnt help. The solution they gave didn't work.
April 30, 2004 at 10:15 am
What version of SQL Server 2000 was it?
-SQLBill
April 30, 2004 at 10:16 am
Almost forgot - what size is the database you are trying to restore to MSDE?
-SQLBill
May 3, 2004 at 1:03 am
Sql server 2000 develper edition. The size of the database is about 4.5MB. I detacahed the database from one sql server 2000 and attached it to another sql server 2000 and it worked. I guess the problem is attaching it to msde.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply