Full BACKUP DATABASE + differential backup, restore to another server

Material: one copy of the full backup database, a differential backup of the most recent backup

Now it needs to be fully restored to another database server.

First of all

Left database-right-restore Database

Then the target database manually enters a name.

The following source device selects the full database file and then determines that it will appear in the Select backup set for restore there, tick the full copy. Then the left option to fill in the MDF file path, etc.

The main thing is to choose the middle option so that you can continue to restore the differential backup when you're done.

Click Confirm, the data begins to recover, after the recovery, refresh the left of the database list, you will find just the input database name, display is being restored ...

Then continue to point the task to restore files and filegroups, select the differential backup file, the option to fill in the correct MDF file and the LDF file path, then the most important is the following three options select the first, and then click Confirm, you can restore to the differential backup last minute

Full BACKUP DATABASE + differential backup, restore to another server