Restore SQL database Using SQL Server Management Studio
in my previous tutorial we talk about MS SQL database backup steps and verify the backup and now I will walk through database restore steps
Connect to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
Right-click the database, then click Restore Database.
In the Restore Database window select “From device” as a source for restore, if you are restoring from .bak file and click the button to search for .bak file
Click “Add” then locate the Database file .bak and click “OK”
Select the restore options and restore folder for the database and log files
In the Destination to restore, fill “To database” field from the list box select the database name to. You can optionally type a new name then click OK to start restore the database
Windows below will appear after the database restored successfully
For Additional information
Restore a Database Backup Using SSMS
https://msdn.microsoft.com/en-us/library/ms177429.aspx
RESTORE (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms186858.aspx