SQL Server Performance

PageAudit Property is Incorrect

Discussion in 'SQL Server 2005 General DBA Questions' started by ghemant, Mar 28, 2007.

  1. ghemant Moderator

    Dear All,
    Their is a suspected databases on server for which i tried bring it back online but it was not success this database had torn page errors and it goes in Suspect mode,while i tried attaching a single MDF file, I got below error, i think i could not recover this anymore did i raise a PSS Ticket or even they couldn't solve this!! :
    Server: Msg 5172, Level 16, State 15, Line 1
    The header for file 'H:MS SQL ServerDATAMyDbs.mdf' is not a valid database file header. The PageAudit property is incorrect.

    Any suggestion/direction please.

    Hemantgiri S. Goswami
    MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
  2. Luis Martin Moderator

    Check:
    http://support.microsoft.com/kb/268481

    HTH

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. ghemant Moderator

    Hi Luis,
    i have checked this link before posting this issue I am going to try this today night and get back here; could you suggest any other way!!!

    Thank you

    Hemantgiri S. Goswami
    MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
  4. ghemant Moderator

    Hi All,
    Database is now online,here is the workaround:
    they have renamed the physical file name of the database this was the reason it went into Suspect mode we changed it to the original name.

    Regards

    Hemantgiri S. Goswami
    MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
  5. MohammedU New Member

    Thaks for sharing...
    That is interesting error...
    May be it is check the information from "dbcc checkprimaryfile" output...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  6. satya Moderator

    Thats a good call on the checking the consistency of physical file, when copied from one to another machine it might happen. It was already in suspect state that means there is an inconsistency between the database pages and disk linkage.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page