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

avatar image

mituljain9
30 4 4 7

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

avatar image

ThomasRushton ♦♦
40.3k 20 49 53

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

avatar image

Kev Riley ♦♦
64.2k 48 62 81

(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

avatar image

mituljain9
30 4 4 7

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

avatar image

ramesh 1
2.2k 66 69 73

(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:

x124

asked: May 31, 2012 at 03:09 PM

Seen: 2394 times

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

Copyright 2016 Redgate Software. Privacy Policy