Forum Discussion
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.
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.
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.
Run the following command and share the value of m_type
DBCC TRACEON (3604)
DBCC PAGE ('Empty', 1, 0, 3)
DBCC TRACEON (3604)
DBCC PAGE ('Empty', 1, 0, 3)
- m_type is 15.
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.
- Thank you so much, Robin. blog fixed my problem.