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!