SQL Server Database backup instructions

SQL Server settings full backup, differential backup description

In the Database Manager, select the database you want to back up, right-click the backup

You can then back up as a backup.

For the restoration of files, make the following additional notes:

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.

Do not revert to special circumstances, the data is priceless, please handle it carefully.

SQL Server Database backup instructions