In the Restore Database window, select the database to restore, choose the FULL backup, and select the differential sets to restore, and press OK. Alternatively, you can use the T-SQL commands to ...

Once you disconnect a database, you must restore it from its .MDF file in ... program's graphical interface or through typed Transact-SQL text commands. Click the "Start" button.

However, running this command may result in data loss. Alternatively, you can use a professional SQL database repair software, like Stellar Repair for MS SQL. It can repair corrupt SQL database ...

How to quickly back up and restore a database ... click on the SQL tab and, in the query pane (Figure D — the text area above the Submit Query button) type: drop database NAME; Where NAME ...