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, we need to follow the below steps, 

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

  • Restore the database wizard, which will open, select the path and select backup database with .bak. Click 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 per your requirement and click OK to start the recovery of the database.

  • If you click OK, backup database will be shown on the connected object SSMS Server.

    See more about restore from technet