Select Backup Type & Database

This topic describes the wizard page for selecting the type of backup you want to perform and the databases that you want to back up.

Backup type

Select the type of backup you require:

• Full Database creates a complete copy of the selected database.
• Differential Database creates a partial copy of the selected database.
• Only the changes since the last full backup was made are copied. You must create a full backup of the database before you can perform a differential backup.
• Transaction log copies all the log records that have been written to the live transaction log since the last full, differential, or transaction log backup (whichever was most recent).
• You can back up the live transaction log only if the database uses the FULL or BULK LOGGED recovery model, and you have previously created a full backup. To truncate the live transaction log, select the Remove inactive entries from transaction log check box.
• Filegroups or files creates a backup of selected files and filegroups.

For example, you may want to back up a file or filegroup when the database size makes a full database backup impractical. You can create a filegroup or files backup for only one database at a time. The database must use full or bulk-logged recovery model.

You will be prompted to select the files and filegroups when you click Next.

files recovery digital camera	files retrieval software	lost files utilities
data recovery software downloads	file recovery software downloads	data restoration tool
Download data salvage software	Data Doctor Recovery Windows FAT	Best file recovery software

 

Databases

To select the databases that you want to back up, select the check box next to each database that you want to back up.

Note that only those databases that can be backed up with the backup type you selected are available. For example, if you selected Differential, only databases that have already had a full backup are available.

By default, all databases are displayed in the list, and those that are not available for selection given the selected backup type are displayed in gray. To see the reason why a database is not available, move your mouse pointer over the database name. In the example below, the Filegroups or files backup type has been selected.

You can filter the list so that only available databases are displayed in the list by selecting the Filter list to show only databases eligible for chosen backup type check box.

Click Next when you have selected the databases.

If you have chosen to back up files or filegroups, the Back Up wizard displays a page for you to select the files. The files and filegroups for the database you selected are displayed in a hierarchy. To select a file, select the appropriate check box. If you select the check box for a folder, all files and filegroups within that folder are automatically selected. When you have made your selection, click Next.