Restore a database using SQL Server Management Studio

Thursday 12 June 2014, by Younus Kazi

Step by step guide

In Object Explorer, click the server name to expand the server tree. Expand Databases, Right-click the database, point to Tasks, and then click Restore and then click Database, which opens the Restore Database dialog box.
The following Restore Database windows will appear. Select From device mentioned under the Source for restore and click the button in front of that to specify the file location.
Select the option Backup media as File and click on the Add button to add the backup file location.
Select the backup file you wish to restore and Hit the OK button.

About The Author

This article was posted by Younus Kazi.

Related posts:

Join the discussion by adding your comments below:

« Back to the Learning Blog

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT

Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom

☎️ +44 (0)208 432 6218

WhatsApp: +44 0749 461 6045

Chat with London Academy of IT on WhatsApp

Share this page now!

2012 - 2025 © London Academy of IT Limited. All Rights Reserved.
Registered in England & Wales with company no. 07923992.