I have website developed in asp.net and used SQL Server 2012 for database, my task to make website responsive, I have decided make changes locally first, I have whole source through ftp, and downloaded database backup from control panel.

My problem is that when I try to restore downloaded db backup file, it keeps showing me error message "No backupset selected to be restored", please check attached screen. I am new to ASP.NET / SQL Server 2012, can any one help me to solve this issue ?


1 Answer 1


This could be caused by any number of issues.

To help get to the bottom of this I would, In SSMS open a new query window and run the following command

RESTORE DATABASE [DatabaseNameHere] 
FROM DISK='Path to the backup file here'

e.g. if my database was called AdventureWorks and the backup was located in c:\Temp\Adventureworks.bak the TSQL would be.

RESTORE DATABASE [AdventureWorks] 
FROM DISK='c:\Temp\Adventureworks.bak'

The error produced will give you a much better indication as to what the issue is.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.