Restore Incomplete BAK file

  • Hi everyone

    this is my first post on this forum, hope you can help me!!!

    I am trying to do a restore of a BAK file and eventually managed to trouble shoot it to the back file being incomplete. I got this by running RESTORE HEADERONLY and got the value **INCOMPLETE** in the BackupName column.

    I also ran RESTORE VERIFYONLY FROM DISK and got this error

    The file on device 'X:\example.bak' is not a valid Microsoft Tape Format backup set.

    Is it possible to restore this at all?

    The bak file this database is from is still up and running on another SQL system, how can I check to see the bak files are good?

    I'v only been doing SQL since yesterday...usual IT small violin story!

  • are you restoring with correct version...

    what i mean is...

    lets say if the backup was taken by litespeed and you trying to restore from management studio or by sql server restore database command then you will get this error. As well so do in reverse case.

    If backup and restore is from same media then file is corrupt. I think there are some tools online which can help you to judge further either the backup is still valid or not

    ----------
    Ashish

  • I too agree with Ashish as if this backup is native sql backup then only you shud use SSMS or query analyzer to restore this, if this is a redgate or lightspeed backup then this is not going to work.

    will suggest you to go back and check how this backup wast taken initally.

    Rohit

  • Where did the backup come from? What version of SQL and what tool? Where are you restoring it? What version of sql?

    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
  • I also facing to the same error. Actually my server (win2003) was corrupted when I was taking the backup. My Sql server is 2000 in it was in a Raid5 server. Finally I was managed to retrieve only the backup file, but unfortunately default SQL restore database restore gives me the below error:

    link:https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

    Then, I used "RESTORE HEADERONLY " command and giving me below:

    link:https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

    "RESTORE VERIFYONLY" command giving me the following:

    Link:https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

    "RESTORE DATABASE" command giving me the below error:

    link:https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

    Could you please help me?

  • Please post new questions in a new thread and include error messages in text (you can copy from any error dialog in SSMS)

    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

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

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