Let’s imagine the following situation. You have SQL Server database and you perform backups from time to time. Something went wrong and now you need to restore your SQL Server database. You start to do it with the help of SSMS (SQL Server Management Studio) but face with the following error message: “No Backupset Selected to be Restored“.
No Backupset Selected to be Restored – Causes and Solutions
We have researched this issue and found out the next, you can receive No Backupset Selected to be Restored because:
- 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.
- The backup file is unreadable or corrupted. You can simply check your database backup using the following command:
RESTORE HEADERONLY FROM DISK='D:\Adventureworks.bak'
To avoid such error message in the future we recommend you to create SQL Server database backups with the help of SqlBak. SqlBak can backup your databases automatically, according to your schedule and send backups to selected destination place. Also, if the failure occurs or there is a need to restore a database, you can do it in few minutes. Here is a simple tutorial how to backup SQL Server and how to restore your database.
6 thoughts on “No Backupset Selected to be Restored”
but in my case it was permission issue, u need rights ( admin rights )
Msg 3241, Level 16, State 7, Line 6
The media family on device ‘F:\Jijo\SourceCode\ERP_FILES\ERP201521Dec2015.bak’ is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 6
RESTORE HEADERONLY is terminating abnormally.
pls help me
Great article, exactly what I needed.
Will this occur even if the DB back up from 2014 SP2 is tried to be restored to 2014 of SP1 version?
Try to overwrite existing backup sets during the Database backup and give it a try, It works for me.
DB backup=>Options = > Overwrite existing backup sets