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 backup error Expand / Collapse
Author
Message
Posted Friday, September 27, 2013 4:57 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 12:24 PM
Points: 3,098, Visits: 3,231
Hi All,

How are you doing with error messages like this one:

Msg 3242, Level 16, State 2, Line 1
The file on device 'D:\Backups\database.bak' is not a valid Microsoft Tape Format backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

I got a backup from a client but cannot restore it.
I tried with CONTINUE_AFTER_ERROR as well, but same.

Actually
RESTORE VERIFYONLY FROM DISK = N'D:\Backups\database.bak'

gives out the same error.






Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1499309
Posted Friday, September 27, 2013 5:17 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 5:31 AM
Points: 4,429, Visits: 4,183
Can you do a Restore HEADERONLY ?


Markus Bohse
Post #1499316
Posted Friday, September 27, 2013 5:40 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 12:24 PM
Points: 3,098, Visits: 3,231
MarkusB (9/27/2013)
Can you do a Restore HEADERONLY ?

Yes I'm able to do it





Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1499324
Posted Friday, September 27, 2013 5:42 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 12:24 PM
Points: 3,098, Visits: 3,231
IgorMi (9/27/2013)
MarkusB (9/27/2013)
Can you do a Restore HEADERONLY ?

Yes I'm able to do it



BackupName BackupDescription BackupType ExpirationDate Compressed Position DeviceType UserName ServerName DatabaseName DatabaseVersion DatabaseCreationDate BackupSize FirstLSN LastLSN CheckpointLSN DatabaseBackupLSN BackupStartDate BackupFinishDate SortOrder CodePage UnicodeLocaleId UnicodeComparisonStyle CompatibilityLevel SoftwareVendorId SoftwareVersionMajor SoftwareVersionMinor SoftwareVersionBuild MachineName Flags BindingID RecoveryForkID Collation FamilyGUID HasBulkLoggedData IsSnapshot IsReadOnly IsSingleUser HasBackupChecksums IsDamaged BeginsLogChain HasIncompleteMetaData IsForceOffline IsCopyOnly FirstRecoveryForkID ForkPointLSN RecoveryModel DifferentialBaseLSN DifferentialBaseGUID BackupTypeDescription BackupSetGUID CompressedBackupSize
*** INCOMPLETE *** NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1499325
Posted Friday, September 27, 2013 5:48 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 5:31 AM
Points: 4,429, Visits: 4,183
That doesn't look good.
Your backup file is definetly not ok. Could it be that the backup was taken on a different version of SQL Server than your own server?


Markus Bohse
Post #1499327
Posted Friday, September 27, 2013 5:51 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 12:24 PM
Points: 3,098, Visits: 3,231
MarkusB (9/27/2013)
That doesn't look good.
Your backup file is definetly not ok. Could it be that the backup was taken on a different version of SQL Server than your own server?


Both instances (the client and my) are on sql server 2008 r2, but I'm not sure about the versions on them.
I think their version is later than mine, ... will try to restore on sql server 2012 or 2008r2 upgraded as their version.

Thank you
IgorMi




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1499328
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse