SQL Server Database backup instructions

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.