x

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.

more ▼

asked May 31, 2012 at 03:09 PM in Default

mituljain9 gravatar image

mituljain9
30 4 4 6

A 3013 error is usually accompanied by another error message that details the cause - do you have any other messages?
May 31, 2012 at 03:14 PM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

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?
more ▼

answered May 31, 2012 at 03:15 PM

ThomasRushton gravatar image

ThomasRushton ♦
34.2k 18 20 44

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, 2012 at 03:32 PM mituljain9
So, are there any other error messages? If so, what are they?
May 31, 2012 at 04:12 PM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left
It could be that you are trying to restore onto a different version that is lower on local than on the server?
more ▼

answered May 31, 2012 at 03:16 PM

Kev Riley gravatar image

Kev Riley ♦♦
54.3k 47 49 76

(comments are locked)
10|1200 characters needed characters left
no, this is the only error i got while making the restore....
more ▼

answered Jun 01, 2012 at 04:24 AM

mituljain9 gravatar image

mituljain9
30 4 4 6

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.
Jun 01, 2012 at 06:38 AM Usman Butt
look in the SQL Server Log too
Jun 01, 2012 at 10:59 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
restore verifyonly from disk =' path of .bak file'
more ▼

answered Sep 06, 2013 at 01:06 PM

ramesh 1 gravatar image

ramesh 1
2.2k 63 67 69

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x103

asked: May 31, 2012 at 03:09 PM

Seen: 1923 times

Last Updated: Sep 06, 2013 at 01:06 PM