August 19, 2008 at 8:53 am
Hi guys
what might be the reason for this error before that i need to say this back up file we are getting from outside vendor
Please provide possible reasons
it is not encrypted backup set
Failed to read backup files.error message:
the file on device 'Fxxxxx.bak'is not valid Microsoft Tape Format backup set.
terminating restore.
August 19, 2008 at 9:12 am
shree (8/19/2008)
Hi guyswhat might be the reason for this error before that i need to say this back up file we are getting from outside vendor
Please provide possible reasons
it is not encrypted backup set
Failed to read backup files.error message:
the file on device 'Fxxxxx.bak'is not valid Microsoft Tape Format backup set.
terminating restore.
Do you know what version of SQL Server the backup was made on? Can you check the the file starts with "TAPE" (the characters TAPE should be the first four characters if you open the file in a text editor).
If this is the case, try using: RESTORE HEADERONLY on the file and see what information this returns.
Regards,
Andras
August 19, 2008 at 10:37 am
As you said when i open it in txt editor i see first four Letters are 'TAPE'
but when issue restore header only command it gave the below error
Server: Msg 3242, Level 16, State 1, Line 1
The file on device xxxxx_200806160942.BAK' is not a valid Microsoft Tape Format backup set.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE HEADERONLY is terminating abnormally.
August 20, 2008 at 2:48 am
shree (8/19/2008)
As you said when i open it in txt editor i see first four Letters are 'TAPE'but when issue restore header only command it gave the below error
Server: Msg 3242, Level 16, State 1, Line 1
The file on device xxxxx_200806160942.BAK' is not a valid Microsoft Tape Format backup set.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE HEADERONLY is terminating abnormally.
If the backup has been created by SQL Server 7 or later, then the backup file is most likely has been damaged. Has the backup completed successfully when your vendor made it? Is your vendor able to use that backup (enough to do a RESTORE HEADERONLY) on his machine?
Regards,
Andras
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply