debugsqlMinor
Unable to restore backup taken on one server onto another server
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:
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
Database version was checked through the query
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
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 FILELISTONLYandRESTORE VERIFYONLYalso 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:
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
Even
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 HereEven
Remus Rusanu answer also in dbastackstange related to Network drive with same error message HereCode Snippets
RESTORE HEADERONLY FROM DISK='D:/DatabaseBackupFileName.bak';Context
StackExchange Database Administrators Q#123750, answer score: 2
Revisions (0)
No revisions yet.