SQL Backup 5   

Creating Backups: Select the Backup Type and Databases

See Also
Creating Backups > Specify SQL Server > Select Backup Type and Database > File Settings > Processing and Completion Settings > Review Summary

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:

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 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. 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.