question

mituljain9 avatar image
mituljain9 asked

Restore Error

Hi, I am trying to restore on backup file from one of the servers to other local, but I am getting error of "RESTORE HEADERONLY is Terminating Abnormally (Microsoft SQL Server Error:3013)". Please let me know what can I do to make the restore. As this backup file is working fine on one of the other servers absolutly fine.
restore
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
A 3013 error is usually accompanied by another error message that details the cause - do you have any other messages?
1 Like 1 ·
ThomasRushton avatar image
ThomasRushton answered
Could be a corrupt backup file, could be the wrong version of SQL Server... Are you attempting to restore to the same version (or later) of SQL? ie the backup was taken on a 2008r2 box and is being restored to the same? Or is it a 2008r2 backup that you're attempting to restore to a 2005 server?
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

mituljain9 avatar image mituljain9 commented ·
At both the places there is sql 2008 version.......still getting error.......also, this file is getting restored perfectly fine on one other server.......
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
So, are there any other error messages? If so, what are they?
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered
It could be that you are trying to restore onto a different version that is lower on local than on the server?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

mituljain9 avatar image
mituljain9 answered
no, this is the only error i got while making the restore....
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Usman Butt avatar image Usman Butt commented ·
Can you please post the results of the following snippet from both the servers SELECT @@version Also, can you please try copying the backup again from the network and then restore. If it is copied through some other source (other than network), then a better way could be to have a zip/rar file encrypted with password.
1 Like 1 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
look in the SQL Server Log too
1 Like 1 ·
ramesh 1 avatar image
ramesh 1 answered
restore verifyonly from disk =' path of .bak file'
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.