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