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.

Backup SQL Database – Check this related tutorial which helps you to correctly do the backup of SQL 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 Device for the Source 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
Custom Paging in SQL Server is a technique to make the data retirval fast and light weight. Here only the need data of the current page is fetched.

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
In SQL Server, other than Backup and Restore of database, there is also an option to Script Database with it’s complete data.

SHARE THIS ARTICLE

  • linkedin
  • reddit
yogihosting

ABOUT THE AUTHOR

I hope you enjoyed reading this tutorial. If it helped you then consider buying a cup of coffee for me. This will help me in writing more such good tutorials for the readers. Thank you. Buy Me A Coffee donate