PageAudit Property is Incorrect | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

PageAudit Property is Incorrect

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
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.
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
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
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.

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.
]]>