Scheduling Backups: Select the Backup Type and Database |
See Also |
Scheduling Backups > Specify SQL Server> > Select Backup Type and Database > Create Backup Schedules > File Settings > Processing and Completion Settings > Review Summary |
This topic describes the wizard page for selecting the databases that you want to back up, and the type of backup you want to perform.
Select the types of backup you require; you can select a combination of backup types and a separate job will be created for each backup type you select.
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.
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.
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. 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.
For full, differential, or transaction log backups:
Selecting System or User selects all databases within that group. Included databases are marked with
Excluded databases are marked with
For filegroups or files, you can select only one database; click the database in the list.
Note that only those databases that can be backed up with the backup type you selected are available. For example, if you selected Transaction log, only databases that use full or bulk-logged recovery model 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. If you are using Exclude these, databases that are not available are automatically excluded. 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.
See Also |
Scheduling Backups | Specify SQL Server | Create Backup Schedules | File Settings | Processing and Completion Settings | Review Summary
© Red Gate Software Ltd 2007. All Rights Reserved.