Post reply

PageAudit property after disk crash

  • December 27, 2005 at 8:06 pm

    #169950

    We're trying to recover two databases from a disk crash. We have mirrored drives on the server (Windows NT - 5.0 (2195). One crashed, and after remirroring the database gave this message:

    "The header for file 'D:\.MDF' is not a valid database file header. The PageAudit property is incorrect."

    We do not have backups for this database!

    The SQL Server version is 8.00.194 (RTM).

    I've tried putting the databases in emergency mode, but can only get them in (suspect/emergency). I've tried copying the files to another server, creating a database with the same name and file locations, shutting down SQL Server, and replacing the new, clean datafiles with the files from the crashed server. I get the same result.

    Any attempt to run a dbcc command gives "Server: Msg 5180, Level 22, State 1, Line 1

    Could not open FCB for invalid file ID 0 in database '".

    I'd really appreciate your help!

  • December 29, 2005 at 10:20 am

    #611968

    Since "We do not have backups for this database!" I believe that your only course is to call MS PSS and hope that they have a solution.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • December 29, 2005 at 10:44 am

    #611982

    Agree. Call PSS and don't mess around with this data.

  • December 29, 2005 at 10:53 am

    #611987

    Thanks for the responses. I called PSS yesterday, and they talked me through trying to get the databases in emergency mode. No luck. I edited the file header of a copy of the .mdf file and tried to attach it to a test server. I now get torn page errors instead of the PageAudit property error. We've sent the files to an outfit in Texas that is going to try to pull the data out of the files, and it will be interesting to see how much they can bring back.

    And I'm learning that even if another group at your company says that they want complete control of their database and they absolve you of responsibility...that isn't much help when the whole company looks bad.

  • December 29, 2005 at 11:19 am

    #612003

    As a DBA you are not as good as your last backup, but only as good as your last restore ... Good Luck !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • December 30, 2005 at 10:38 am

    #612193

    Last night our SysAdmin was able to get the crashed disk up for long enough to read the datafiles off of it. Incredible! It looks like the datafiles are uncorrupted, and we're all set.

    Thanks for your help...

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply