How to Restore Database from stored backup database using SQL Server Management Studio

This topic explains how to restore a full database backup using SQL Server Management Studio. When we are restoring a database from other instance.

To restore the database we need to follow below steps:

• Copy Backup database to SQL server or any of Physical drive.
• Connect to an instance of the SQL Server Database Engine and then expand that instance.
• Right-click Databases and select Restore Database options like below:

• Restore database wizard will get open select path and select backup database with .bak and click on ok.
• On the file options select Log and Database path where you want to save.
• On the Options path leave all default or modify as your requirement and click ok start recovery the database.

• Once if you click on ok, backup database will showing on connected objected SSMS server.

See more about restore from technet:

https://msdn.microsoft.com/en-us/library/ms177429.aspx

Thanks ☺