How to restore a SQL database?
Open the SQL Server Management Studio and connect to the instance.
Unfold the database tree.
Right click on the database - Task - Restore - Database. In case you have created a new Instance and you want to restore a Database from another computer right click on the databases folder - Restore Database...
Click on Device - ... - Add and look for the back-up that you have created.
Click OK to confirm the selection. After the restoring process is finished a pop up will appear.