Results 1 to 4 of 4

Thread: Attach .mdf file from SCSI Raid 5

  1. #1
    Join Date
    Jul 2006
    Posts
    4

    Attach .mdf file from SCSI Raid 5

    Hi friends,

    I need your help about my problem:
    My server SCSI Raid 5 is crash with my SQL Server within, and i have recovery my data using program "Getdataback" which successfuly retrieve my .mdf and .ldf file.

    I am attach my .mdf and .ldf file and get error message : "The header for file 'c:\mssql7\data\mydb_data.mdf' is not a valid database file header. The PageAudit property is incorrect."

    For your information, i am using SQL Server 7.0.

    I am realy need your help or info to open .mdf file without using SQL Server to get my data back.

    Thanks alot

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    How did you attch db? You can't attch corrupted db files, and can't open .mdf file without sql server.

  3. #3
    Join Date
    Jul 2006
    Posts
    4
    I attach my db using : right click > All Tasks > Attach Database..
    and using sp_attach_db in Query Analyzer.

    My recovered .mdf file properties seems normal with name, size, date modified, etc. How do i know my .mdf file is corrupt?

    And i have try using tricky way which i get from article "Recovering from a deleted log file on SQL Server" in http://www.spaceprogram.com/knowledg...ile-on_12.html
    but still don't get any result.

    I am realy need help because the data is very important to get back. Thanks alot.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    The file is corrupted if sql doesn't recognize it. Call Microsoft to see if they still support sql7.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •