locked
Corrupted SQL backup file (*.bak). RRS feed

 > 

  • General discussion

  • Discussion
    Sign in to vote
    0
    Sign in to vote

    Dear All,

    I am using sql server 2012 platform and I recently took backup of my SQL server database with the file extension .bak. But when I tried to access my backup file, I wasn't able to open the file any more. I think backup file got corrupted. Please help me to get out of this situation.

    Saturday, May 20, 2017 8:58 AM

All replies

  • Discussion
    Sign in to vote
    0
    Sign in to vote

    Can you do a backup now?

    What is error message you get when trying to do your restore?

    Saturday, May 20, 2017 9:04 AM
  • Discussion
    Sign in to vote
    0
    Sign in to vote 
    RESTORE VERIFYONLY FROM DISK = C:\databasename.BAK   -- verify backup  
    check back is going on currently and backup entry in sql log.

    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    Saturday, May 20, 2017 9:06 AM
  • Discussion
    Sign in to vote
    0
    Sign in to vote

    Yes. The new backup can be done and the file can be used.

    The issue details is as follows:

    We re-imaged the server few days back and reinstalled SQL application but at restoring stage, the backup file could't be restored.

    The error message is as follows:

    System.Data.SqlClient.SqlError:The media family on device'C:\backup\1.bak' is incorrectly formed. SQL server cannot process this media family.

    Saturday, May 20, 2017 9:34 AM
  • Discussion
    Sign in to vote
    0
    Sign in to vote
    From what I gather you are running SQL 2012. What version of SQL Server was the backup done in? SQL 2012?
    Saturday, May 20, 2017 9:47 AM
  • Discussion
    Sign in to vote
    0
    Sign in to vote

    Right-click on the database and restore the database.

    Thursday, June 8, 2017 9:25 AM
  • Discussion
    Sign in to vote
    0
    Sign in to vote

    Dear All,

    I am using sql server 2012 platform and I recently took backup of my SQL server database with the file extension .bak. But when I tried to access my backup file, I wasn't able to open the file any more. I think backup file got corrupted. Please help me to get out of this situation.

    So can you not go ahead and take other backup, zip it and copy and restore ? Guys this is too old thread please stop posting on it specially Pascal.

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles
    MVP


    Tuesday, October 9, 2018 7:41 AM
  • Discussion
    Sign in to vote
    0
    Sign in to vote

    That message almost always is caused by trying to restore a newer version backup to an older version of SQL Server.

    Please check your versions.

    Tuesday, August 11, 2020 12:29 PM