Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

"The file size property is incorrect" - MSSQL Error 5172 Expand / Collapse
Posted Thursday, April 22, 2010 5:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 22, 2010 5:35 PM
Points: 1, Visits: 0
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!
Post #909097
Posted Monday, May 3, 2010 12:46 AM



Group: General Forum Members
Last Login: Today @ 5:58 AM
Points: 2,997, Visits: 4,954
Seems like ur file is corrupted...
Post #914482
Posted Monday, May 3, 2010 1:06 AM



Group: General Forum Members
Last Login: Yesterday @ 5:18 AM
Points: 45,619, Visits: 44,147
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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #914488
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse