Forum Discussion

Stacy Clark's avatar
Stacy Clark
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. 
  • 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.

7 Replies

  • Robin Shanab's avatar
    Robin Shanab
    Iron Contributor
    Hi Stacy,
    Please share the complete error message. It will help to understand the issue.
    • Stacy Clark's avatar
      Stacy Clark
      Brass Contributor

      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's avatar
        Robin Shanab
        Iron Contributor
        Run the following command and share the value of m_type
        DBCC TRACEON (3604)
        DBCC PAGE ('Empty', 1, 0, 3)
  • ashwanit1515's avatar
    ashwanit1515
    Copper Contributor

    Hi, Stacy Clark 

     

    I found an informative document, plz have a look. It might help you:

     

    https://www.systoolsgroup.com/updates/resolve-sql-server-error-5172/ 

Resources