| |||||
One-Click SQL Restore is a lightweight and easy to use application that will enable you to restore the data from a database backup created using BACKUP DATABASE command or SQLBackupAndFTP.
It unzips the bak file if necessary, it connects to the SQL server on the start, it selects the right database, it is smart enough to restart the server to drop open connections if necessary - all you have to do is to press "Restore" button.
One-Click SQL Restore is most useful if you restore often. If you are a developer that needs to restore databases a number of times - it will save you tons of time. However it won't replace the RESTORE command in a complicated restore scenario.

Via: One-Click SQL Restore 2.1.2