April 22, 2010 at 5:48 pm
I'm running an MSSQL 2005 server on a Windows 2008 platform, and I am trying to attach a database. I don't know the history of these database files, but I have an .mdf, a .ndf, and a .ldf file that are all about 3GB in size.
I open up Management Studio, and when I try to attach the .mdf file, I get the error:
"The header for file 'Path\to\file.MDF' is not a valid database file header. The FILE SIZE property is incorrect. (Microsoft SQL Server, Error: 5172)."
I'm not sure of what these files went through before they came to me, but after seeing the .mdf I assumed they had been detached and could be reattached on a new machine. If anyone could offer some help or advice about this error message, I would appreciate it. Thanks!
May 3, 2010 at 12:46 am
Seems like ur file is corrupted...
May 3, 2010 at 1:06 am
If the file header is damaged, the database cannot be opened. That's one of the things that there's no workaround for.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply