HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

Unable to restore backup taken on one server onto another server

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
unableoneontotakenanotherserverrestorebackup

Problem

I am using SQL Server 2014 version 12.0.2000.8 on both systems. When I try to restore the backup taken from the first system onto the second system it says:


No backup set selected to be restored

However I can restore it on the first system without any errors. I also tried to restore using the following command:

RESTORE DATABASE EBS_ATM 
FROM DISK = 'G:\ebsBkup\ebs_bkup.bak'


The above command threw the following error message:


Msg 3013, Level 16, State 1, Line 3

RESTORE DATABASE is terminating abnormally.

I have checked rights and permissions on the folder as well as the .bak file.

Database version was checked through the query DetermineVersionOfSQLServer.sql in the Microsoft Knowledge Base article, How to determine the version, edition and update level of SQL Server and its components.

  • The database does not already exist on the second instance



  • RESTORE FILELISTONLY and RESTORE VERIFYONLY also throw error 3103



  • I know there should be another message before the 3013 eror, but I am getting only the messages I have posted.



The bak file is quite big ~70 GB. First I 7zipped and copy-pasted. Didn't work. Then I 7Zipped in 700 MB tranches. Didn't work. Finally I copied without zipping. Didnt work.

I would appreciate any help on this.

Solution

No backup set selected to be restored

As SqlBak Blog Here the above error comes in two scenario.


1)You are trying to restore your database to a lower version of SQL
Server. If you make a database backup on a higher version, let’s say
SQL Server 2012 and then you try to restore it on SQL Server 2004, you
will get this error message: No Backupset Selected to be Restored.


2)The backup file is unreadable or corrupted. You can simply check
your database backup using the following command:

RESTORE HEADERONLY FROM DISK='D:/DatabaseBackupFileName.bak';


I think as my knowledge it's a incomplete error message. Because most of the time along with Msg 3013, Level 16, State 1, Line 3, the operating system errors (like Operating system Error 3,5 etc) or some error come.


Msg 3013, Level 16, State 1, Line 3 RESTORE DATABASE is terminating
abnormally.

For this error i would recommend to Pinal Dave blog Here,Here and MSDN Blog Here

Even Remus Rusanu answer also in dbastackstange related to Network drive with same error message Here

Code Snippets

RESTORE HEADERONLY FROM DISK='D:/DatabaseBackupFileName.bak';

Context

StackExchange Database Administrators Q#123750, answer score: 2

Revisions (0)

No revisions yet.