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
andRESTORE 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.
WITH INIT
so that there is no confusion about which backup file to use. You probably need to useWITH MOVE
on the restore as well, unless the data/log paths match exactly on both systems.