In the Restore Database window, select the database and the backup sets to restore, and press OK. How to Restore a Backup Using T-SQL Alternatively, you can use the T-SQL commands to restore a ...

How to Restore a SQL Database From a .MDF File. Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure.

It wouldn't make any sense to do anything else. Of course, I haven't tested this because I don't have a live test database to trash.