SQL Backup 5   

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.

Backup type

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.

Databases to back up

For full, differential, or transaction log backups:

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.

 

 

 


© Red Gate Software Ltd 2007. All Rights Reserved.