How to Restore Database in SQL Server

How to Restore Database in SQL Server

If you have the Database Backup File then you can easily restore it to your SQL Server. I will use SQL Server Management Studio (SSMS) to restore the database.

Steps to Restore Database in SQL Server
Follow the below steps that will help you to restore your database.

STEP 1: Select “Restore Database” Option

In the SQL Server Management Studio (SSMS) right click the Database node and select Restore Database. This will open the Restore Database window.

select restore database option

STEP 2: Select “Device”

In the Restore Database window select DeviceSource option and click the button.

This opens Select backup devices window.

select device option

STEP 3: Select Backup Devices

In the Select backup devices window click the Add button. This opens Locate Backup File window.

select backup devices

STEP 4: Locate Backup File

In the Locate Backup File select the backup file of your database and click the OK button.

locate backup file

You will see the Select backup devices window now contains the location of the database backup file. So click the OK button on the Select backup devices window too.

select backup devices with database backup location

STEP 5: Overwrite Existing Database

You will see the Restore Database window is now ready to restore the database. Click the Options link on the top left corner.

click options on restore database window

Here in the Restore options check the option that says Overwrite the existing database (WITH REPLACE) and finally click the OK button.

Overwrite Existing Database

Your database will be restored and SSMS will show the success message.

database restore success message

Share this article -

yogihosting

ABOUT THE AUTHOR

This article has been written by the Technical Staff of YogiHosting. Check out other articles on "WordPress, SEO, jQuery, HTML" and more.