"No backupset selected to be restored" SQL Server 2012

sql-server restore sql-server-2012
Saeed Neamati picture Saeed Neamati · Aug 25, 2012 · Viewed 290.1k times · Source

I have a SQL Server 2012 database with filestream enabled. However, when I backup it and try to restore it on another SQL Server 2012 instance (on another machine), I simply get this message that:

No backupset selected to be restored.

Not even a single line of more explanation. What's wrong here?

Every other database without filestream is OK and can be restored successfully. Is it something related to filestream? Should I install a hotfix or something like that.

Answer

user489998 picture user489998 · Aug 28, 2012

I had this problem and it turned out I was trying to restore to the wrong version of SQL. If you want more information on what's going on, try restoring the database using the following SQL:

RESTORE DATABASE <YourDatabase> 
FROM DISK='<the path to your backup file>\<YourDatabase>.bak'

That should give you the error message that you need to debug this.

Related questions

Error restoring database backup

I am getting an error using SQL Server 2012 when restoring a backup made with a previous version (SQL Server 2008). I actually have several backup files of the same database (taken at different times in the past). The newest ones are …

Read More
Backup and restore SQL Server database filegroup

I use sql server and have a huge database that partitioned by date in multiple file groups. the database filegroups is PRIMARY, FG2010, FG2011, FG2012, FG2013, and FG2014, that FG2010, FG2011, FG2012 and FG2013 is readonly. Now, the backup scenario …

Read More
SQL Server: Database stuck in "Restoring" state

I backed up a database: BACKUP DATABASE MyDatabase TO DISK = 'MyDatabase.bak' WITH INIT --overwrite existing And then tried to restore it: RESTORE DATABASE MyDatabase FROM DISK = 'MyDatabase.bak' WITH REPLACE --force restore over specified database And now the database …

Read More