|
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.
(comments are locked)
|
|
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? At both the places there is sql 2008 version.......still getting error.......also, this file is getting restored perfectly fine on one other server.......
May 31 '12 at 03:32 PM
mituljain9
So, are there any other error messages? If so, what are they?
May 31 '12 at 04:12 PM
ThomasRushton ♦
(comments are locked)
|
|
It could be that you are trying to restore onto a different version that is lower on local than on the server?
(comments are locked)
|
|
no, this is the only error i got while making the restore.... Can you please post the results of the following snippet from both the servers 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.
Jun 01 '12 at 06:38 AM
Usman Butt
look in the SQL Server Log too
Jun 01 '12 at 10:59 AM
Kev Riley ♦♦
(comments are locked)
|
A 3013 error is usually accompanied by another error message that details the cause - do you have any other messages?