Post reply

DATABASE BACKUP FILE CORRUPT

  • May 26, 2016 at 9:44 am

    #400211

    Hi

    I have a database .BAK file that is corrupt and i do not have another copy of that database.

    I need to restore that database but i get an error when i try to do so.

    The error says "invalid"

    please help me in how i can recover this database.

  • May 26, 2016 at 10:25 am

    #1881613

    Short answer, you probably can't.

    What's the command you ran to restore and what's the exact output?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 26, 2016 at 10:36 am

    #1881614

    The error has to say something beyond invalid. Maybe it's a backup from a newer version of SQL Server than where you're trying to restore it? There could be any number of issues here. Can you provide the information that Gail is asking for?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 26, 2016 at 10:55 pm

    #1881738

    Do you have the MDF file? If so, you may still be in luck, run sp_attach_single_file_db.

    If this doesn't work for you, then you have only option to use a third party tool like SQL Backup Database Restore[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

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