SQL Server restore full backup and differential backup operation process

This article brings you relevant knowledge about SQL server, which mainly introduces the detailed operations of restoring full backup and differential backup of SQL Server. This article introduces it to you in the form of pictures and texts. Let’s take a look at the details below, I hope it will be helpful to everyone.

## Recommended study: "

SQL Tutorial"

1. First, right-click the database and click Restore Database:

Then the restore database window will open, as shown in the figure:

First "source" select the device, and select to complete Backup database backup file
• Then in the "target" database, you can directly fill in the database name after restoration

Then click the file on the left:

It is recommended to check the option "Relocate all files to folders", which is actually the location where the database will be saved after restoration. Of course, it can be restored without checking it.

Then continue to click on the left option:

Overwrite the existing database can be checked or unchecked. If you are restoring to an existing database, it is recommended to check it.

Key points:

Select the recovery status in the first red box:

If you only need to restore the full backup, select
• RESTORE WITH RECOVERY
If you still need to restore the differential backup, select the second red box of
• RESTORE WITH NORECOVERY
## and cancel the default check Select "Perform final log backup before restoring". When I operate it, if I don't cancel this check, an error will appear:

Exclusive access could not be obtained because the database is in use.

Cancel this check and no error will be reported.

After the above operations are completed, you can click OK and wait patiently for the restoration. The larger the database, the longer the restoration time will be.

As shown in the figure, the restoration progress will be displayed in the upper right corner:

If you select

RESTORE WITH RECOVERY

in the recovery state, Then after the restoration is successful, you can access the database normally. But if you select

RESTORE WITH NORECOVERY

, you may see this situation after prompting that the restore is successful:

"Restoring..." appears after the database name, indicating that you still need to restore the differential backup at this time.

Operation steps: Right-click the database-> Tasks-> Restore-> Files and File Groups

##You can see the dialog box:

Select "Source Device", select the differential backup database file that needs to be restored, and then check "Restore".

Click on the left option:

As shown in the picture above, select the database file that needs to be restored.

Click OK to start the restoration.

After prompting that the restoration is successful, refresh the database and you can see that the words "Restore..." in the database have disappeared:

At this point, the database restoration has been completed and the database can be accessed normally.

Recommended study: "

SQL Tutorial

"

The above is the detailed content of SQL Server restore full backup and differential backup operation process. For more information, please follow other related articles on the PHP Chinese website!