SQL Server2005 database restoration/backup (additional database)

Enterprise Manager data backup

Use the enterprise manager to back up multiple data Time-based databases. Open the SQL server Enterprise Manager, expand the management nodes in the SQL SERVER Group, right-click the database maintenance plan, and select create maintenance plan. In the pop-up welcome dialog box, select next and the following dialog box is displayed:

Ms SQL database backup and restoration steps

Select the database you want to back up and next step. In the next step, all options are selected by default. In the current dialog box, you can choose whether to check the integrity of the database. By default, you can proceed to the next step. The following figure shows the dialog box:

Ms SQL database backup and restoration steps

Select the backup database as part of the maintenance plan, click the Change button to modify the backup database time, and click next, as shown in the figure below:

Ms SQL database backup and restoration steps

Here, we can select "use this directory" as the backup path, and select "delete files earlier than this time" to specify the backup file retention time.

Restore by attaching a database

In the SQL database, if the database is restored using the database file, that is, the MDF and LDF files are used to restore the database, there is an additional file in SQL2000, and there is also an additional file in SQL2005.
The process is as follows:

1. Open SQL2005, in the object resource manager, as shown in the figure below, right-click the database and there is an attachment.

2. Click next to the page shown in the following figure. Click add.

3. Select the data you want to restore, as shown in the following figure. Only the MDF file is displayed. After the MDF file is selected, another file is automatically loaded.
If you want to attach multiple databases at the same time, click Add again.

4. After selecting the file, click OK. After running, the database will appear in the object resource manager.

Now you can use this database.

Knowledge Point supplement

Full Backup: backs up all selected folders and does not rely on the file archive attribute to determine which files to back up. (During the backup process, any existing tags are cleared, and each file is marked as backed up. In other words, the archive attribute is cleared ). Full Backup is also called full backup.

Differential backup: differential backup is for full backup: All files that change after the last full backup are backed up. (During differential backup, only the marked files and folders are backed up. It does not clear the mark, that is, it is not marked as a backup file after the backup, in other words, it does not clear the archive attribute ).

Incremental backup: The incremental backup is for the last backup (no matter what type of backup): All files that have changed since the last backup. (During the incremental backup process, only the marked files and folders are backed up. The marked files are cleared, that is, the files are marked after the backup. In other words, the archive attributes are cleared .)

Transaction log backup: Full database backup and last differential backup performed before a specific transaction log backup (if any ). All Transaction log backups performed after the full database backup or differential backups performed before the specific transaction log backup (if you have restored the differential backup ). If you set the recovery mode to simple, you will not be able to use transaction log backup. SQL Server 2000 and SQL Server 2005: Create a transaction log Backup. You must use a full recovery or large-capacity log recovery model.

Partial backup: The backup created by specifying READ_WRITE_FILEGROUPS is called "partial backup ". In simple recovery mode, only file group backup can be performed on read-only file groups. Type of restored data backup: database backup, partial backup, or file backup. For database backup or partial backup, the log backup sequence must start from the end of the database backup or partial backup. For a group of file backups, the log backup sequence must start from the beginning of the entire group of file backups.

File Backup: "File backup" contains all data in one or more files (or file groups.