Troubleshooting Microsoft SQL Server Error 5172

Problem:

SQL Error 5172

In this article we will know: -

  • What is SQL error 5172?
  • Reasons For "file size property is incorrect SQL Server"
  • How to Fix SQL Error 5172 (.mdf is not a valid database file header)?

Solution:

What Is SQL Error 5172?

The SQL Server stores its physical data in primary database file, which contains the data according to pages. The header information of a .mdf file is hold by first page, which is known as the header page. This page contains the important information of that database file like: file size and signature etc.While attaching the .mdf file in SQL Server, One of the most common error users encounter i:e Microsoft SQL Server Error 5172. The issue .mdf is not a valid database file header generally occurs when the header information of a .mdf file gets corrupted. Due to this the header file information got mismatched and the result of this error could be the database becomes inaccessible.

Reasons For "file size property is incorrect SQL Server"

There could be several reasons behind of header information corruption. It could be corrupt due to following reasons:

  • Bad system Shutdown
  • Improper Shutdown of Microsoft SQL Server
  • Malfunctioning of a hardware
  • Virus attacks

These corruption reasons could be result the issue file size property is incorrect SQL Server and make the database file inaccessible or user failed to attach the database file and get this SQL Server error 5172.

In order to fix this error, one can try restoring the recent backup of the database. If you have a latest copy of backup then it is the right time to use it. Sometimes, the Microsoft SQL Error 5172 arises when a higher version database file is attached to a lower version Server. So, make sure that the database file is attached with the right version to prevent such situation.

Another method to solve this database file header issue is to try SQL Database Recovery Software, if you don't have the recent backup. The software is capable to fix the file size property of a database file.

How the Tool Fix File Header Corruption In SQL Server?

Click on Open button, to select the MDF file.
Click on Open Button
Then choose the corrupt or damaged .mdf file and click on Open button as shown in below screenshot.
Select .mdf File.
After this, software will scan the database file and recover the database from damaged .mdf file.
Scanning .mdf File
Once the recovery process is completed by the tool, one can able to view all the database objects.
Preview Recovered Items

Bottom Lines

There could be several reasons behind the header information corruption. The article describes some major issues which could be the cause of SQL Server error 5172. Also, it explains the possible recovery solution to fix the issue .mdf is not a valid database file header.