How to restore backup of SQL Database to SQL Server?

Want to restore BAK file to SQL server? Follow steps given below.

Hide All Screenshots

STEP 1

Open SQL Server 2005 Management Studio.

Connect to the appropriate server.

STEP 2

Expand Databases.

STEP 3

Right-click the desired database, go toTasks, then Restore and then select Database.

STEP 4

The Restore Database window will appear.

STEP 5

Ensure that the correct database name appears in the To database field. If not, select it from the dropdown.

Under Source for restore, select the From device radio button.

Click the button next to the textbox to select the device to restore from.

STEP 6

The Specify Backup window will appear.Click on Add.

STEP 7

Select the backup file from the Locate Backup File Window. Click OK.

STEP 8

Under Select the backup sets to restore, select Restore button.

STEP 9

Under Recovery state, ensure that the Restore with Recovery radio button is selected.

Click OK to begin restoring the database.

Once the restore is complete, a notification box will appear. Click OK to close the box. You have now restored your database to the most recent state.

Note: If you are not able to access your backup of SQL database or it got corrupted, then use our product SysTools SQL Backup Recovery which is used to recover .bak files of SQL database quickly.

Most Frequently Asked