How to restore Database in sql server

In this article I have explained about how to Restore Database using SQL Server.
Each steps I have clearly explained in this article



Step 1: Open SQL Server management Studio
Step 2:Connect to the appropriate Server and right click databases.
Step 3:Select Restore Database then click it (see below image).



Step 4:Restore Database Window will display (See below image).



Step 5:Give Restore Database name (see below image).




Step 6:Select from database or from the device (Here I''m selecting from Device).
Step 7:Click the button nearest from the device. (see below image)



Step 8:Specify Backup window will display (see below image)



Step 9:Click add button and you will get Locate Backup file-Servername window.
Step 10: select your bak files.

Step 11: then click the ok button.
Step 12:Your path will display in Specify Backup window.If an unwanted path is displayed then remove it.
Step 13: if does not have more then one path then click the ok button.
Step 14:The database backup file path will display in Restore database window (see below image)


Step 15: select latest Restore database file.
Step 16: finally click ok button


Step 17: if your database is already in the server then click the options button Click the overwrite the existing database (With Replace) checkbox.