Forum Discussion

Brass Contributor

Jan 18, 2022

Solved

I am facing header corruption error in SQL database.

I am facing a header corruption error in the SQL database. Error msg: 5172, level 16, state 15 the header for the file is not valid. page audit property is incorrect.

Robin Shanab
Jan 19, 2022
Stacy Clark
m_type equal to 15 identifies a page of type header.
Please Check this blog: https://www.stellarsqldatabaserecovery.com/blog/sql-database-error-5172-the-page-control-property-is-incorrect/
It is based on the same error message that you are getting.
Let me know if you have any query.

Robin Shanab

Iron Contributor

Jan 19, 2022

Hi Stacy,
Please share the complete error message. It will help to understand the issue.

Stacy Clark
Brass Contributor
Jan 19, 2022
Robin Shanab
The header for file is not a database file header. The page audit property is incorrect.
Msg 1802, level 16
create database failed, some file names listed could not be created.
- Robin Shanab
  Iron Contributor
  Jan 19, 2022
  Run the following command and share the value of m_type
  DBCC TRACEON (3604)
  DBCC PAGE ('Empty', 1, 0, 3)
  - Stacy Clark
    Brass Contributor
    Jan 19, 2022
    m_type is 15.