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.
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.
Save my name, email, and website in this browser for the next time I comment.
– A WIPL Company
cPanel Cloud VMs
Dedicated Server India
Submit a Ticket
Login to Members Area
AUP ● TOS ● SLA
Refund & Cancellation Policy
Domain Registration Agreement
Copyright Infringement Policy
Data Request Policy