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 ♦
34k 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 ♦♦
53.2k 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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:

x102

asked: May 31, 2012 at 03:09 PM

Seen: 1835 times

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