SQL Server full differential backup restore

Full and differential backup of SQL Server

A full backup is, of course, a backup of all the database data

A differential backup, however, refers to a backup of the changes to the data after the last backup.

Therefore, differential backups cannot be used alone, and you can restore a differential backup only after the last full backup was first restored.

When you have multiple differential backups, you only need to select a differential backup file for the specified date, and you do not have to restore the differential backup individually during this period.

The steps are:

1. Right-click on the database you want to restore

2. In the "General" option, click on "Source Device" to select the backup. bak file on the disk, tick the "restore" option

3. On the "Options" page, tick "Overwrite existing database", restore status, select the first "ROLLBACK UNCOMMITTED transaction ...." , where in row data and log two data rows, be sure to see if the path "revert to" points to the database name Dbname.mdf and dbname_log.ldf that you need to restore, The restore failed because some of the restored database names are different from the names in the. bak backup file.

4. Restore success after clicking OK

When the database file is large, the amount of data is large, backup and restore takes time, the differential backup of the database becomes one of the backup scenarios considered.

There are two ways to backup SQLSERVER2008 differential backups:

1. Make a full backup before making a differential backup, the file of the differential backup or the one with the full backup, so there will be two in the full backup set

Backup files. When restoring, select the diff file, restore options to "Overwrite existing database" and "Roll back uncommitted transactions ..." both

2. Make a full backup, then make a differential backup, the file of the differential backup does not use the full backup of the file, and then create a new differential backup file.

So there are two backup files on the disk for these two backups. When restoring these two backup files, select the full backup file first, select the Restore option

Overwrite existing database and do not perform any operations on the database .... After the restore is complete, you will see that the restored database name is rendered "DBName (restoring ...)"

To restore the database again, select the differential backup file, the direct point is OK.

Steps:

1, first, such as a full backup of the database and then do the differential backup

2, for differential restore when the preferred choice in _ full. bak file to restore, at which time the DB will display dbname (restoring ...)

3. In (Restoring ...) DB name, right-"task-" Restore-"database, select the" Source Device "option, select the difference 2.bak, tick the Restore

Make the following selections on the Options page

When you click OK, the differential restore executes successfully.

Note: We are directly selected for the difference 2.bak restore, so that will also be the difference in 1.bak data to restore to the database, because _ difference 2.bak is from the difference 1.bak on the differential backup.

From:http://www.cnblogs.com/ivanyb/archive/2013/01/23/2873437.html

SQL Server full differential backup restore