Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restore Incomplete BAK file Expand / Collapse
Author
Message
Posted Thursday, August 12, 2010 8:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 13, 2010 3:32 AM
Points: 1, Visits: 2
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!
Post #968223
Posted Thursday, August 12, 2010 8:58 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 10:49 PM
Points: 882, Visits: 4,105
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
Post #968254
Posted Friday, August 13, 2010 3:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:12 AM
Points: 225, Visits: 469
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
Post #968762
Posted Friday, August 13, 2010 4:30 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:43 AM
Points: 39,890, Visits: 36,236
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 2008, MVP
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

Post #968768
Posted Sunday, June 23, 2013 12:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 24, 2013 4:50 AM
Points: 2, Visits: 11
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.dropbox.com/s/hmeeha9ou3xdc8v/error_sqlstate42000.png

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

link:https://www.dropbox.com/s/qn2i0ydmb6ps1cf/restoreHeadonlyresult.png

"RESTORE VERIFYONLY" command giving me the following:

Link:https://www.dropbox.com/s/da6rjcahmrmm119/restoreveryfyonly.png

"RESTORE DATABASE" command giving me the below error:

link:https://www.dropbox.com/s/fegkgl929zjio5j/restoreDatabaseError.png

Could you please help me?
Post #1466506
Posted Sunday, June 23, 2013 4:06 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:43 AM
Points: 39,890, Visits: 36,236
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 2008, MVP
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

Post #1466511
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse