After you connect to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
Expand Databases. Depending on the database, either select a user database or expand System Databases, and then select a system database.
Right-click the database, point to Tasks, point to Restore, and then click Database, which opens the Restore Database dialog box.
On the General page, use the Source section to specify the source and location of the backup sets to restore. Select one of the following options:
Database
Select the database to restore from the drop-down list. The list contains only databases that have been backed up according to the msdb backup history.
On this page of the site you can watch the video online Restore a Database Backup (SQL Server Management Studio) with a duration of hours minute second in good quality, which was uploaded by the user GoPro 24 November 2014, share the link with friends and acquaintances, this video has already been watched 19,599 times on youtube and it was liked by 13 viewers. Enjoy your viewing!