Question
How to restore a SQL database?
Answer
Step 1
Open the SQL Server Management Studio and connect to the instance.
Step 2
Unfold the database tree.
Step 3
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...
Step 4
Click on Device - ... - Add and look for the back-up that you have created.
Step 5
Click OK to confirm the selection. After the restoring process is finished a pop up will appear.