Unable to restore backup taken on one server onto another server 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.
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