- Login to your Server/VPS using your RDP login details.
2. Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
3. Next, go to Object Explorer and click the Server Name to expand the Server tree.
4. Navigate to Databases and open the database you want to restore in SQL Server.
5. Right-click the Database, and then click Restore Database.
6. The Restore Database window is displayed. From the General page, under Source section, select any of these options:
a. Choose the Database option, and then select the database you want to restore from the drop-down list.
b. Choose the Device option, and then click the ellipses (…) to find your backup file.
- From ‘Select backup devices’ window, choose File as backup media, and then click Add.
- Locate and select the .BAK file you want to restore, and then click OK.
- Again click OK to return to the Restore Database window.
7. From‘Select backup devices’ window, choose File as backup media, and then click Add.
8. Select Add to Navigate to .BAK File, Locate and select the .BAK file you want to restore, and then click OK.
9. Select the Backup File, Again click OK to return to the ‘Restore Database’ window.
10. The name of the database to be restored is displayed in the Database box under Destination section. And, information of the selected backup file will be added in the Backup sets to restore section.
b. On the Options page, do the following:
11. To proceed with the restore process, hit the OK button.
12. The window with restore progress is displayed.
13. Click OK when the ‘restore of database completed successfully’ message pops up.