September 27, 2013 at 4:57 am
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,My blog: www.igormicev.com
September 27, 2013 at 5:17 am
Can you do a Restore HEADERONLY ?
[font="Verdana"]Markus Bohse[/font]
September 27, 2013 at 5:40 am
MarkusB (9/27/2013)
Can you do a Restore HEADERONLY ?
Yes I'm able to do it
Igor Micev,My blog: www.igormicev.com
September 27, 2013 at 5:42 am
IgorMi (9/27/2013)
MarkusB (9/27/2013)
Can you do a Restore HEADERONLY ?Yes I'm able to do it
BackupNameBackupDescriptionBackupTypeExpirationDateCompressedPositionDeviceTypeUserNameServerNameDatabaseNameDatabaseVersionDatabaseCreationDateBackupSizeFirstLSNLastLSNCheckpointLSNDatabaseBackupLSNBackupStartDateBackupFinishDateSortOrderCodePageUnicodeLocaleIdUnicodeComparisonStyleCompatibilityLevelSoftwareVendorIdSoftwareVersionMajorSoftwareVersionMinorSoftwareVersionBuildMachineNameFlagsBindingIDRecoveryForkIDCollationFamilyGUIDHasBulkLoggedDataIsSnapshotIsReadOnlyIsSingleUserHasBackupChecksumsIsDamagedBeginsLogChainHasIncompleteMetaDataIsForceOfflineIsCopyOnlyFirstRecoveryForkIDForkPointLSNRecoveryModelDifferentialBaseLSNDifferentialBaseGUIDBackupTypeDescriptionBackupSetGUIDCompressedBackupSize
*** INCOMPLETE ***NULLNULLNULLNULL1NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL
Igor Micev,My blog: www.igormicev.com
September 27, 2013 at 5:48 am
:w00t: 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?
[font="Verdana"]Markus Bohse[/font]
September 27, 2013 at 5:51 am
MarkusB (9/27/2013)
:w00t: 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,My blog: www.igormicev.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply