Online Documentation for SQL Backup for SQL Server

Setting file options


Use this step to define backup file options.

 

Service tasks - Backup Database - SQL Angel backup - Setting file options

 

 

Backup folder

Specify backup destination directory. For your convenience {backup_root_folder} and {server} tags are provided. The directory which the {backup_root_folder} tag stands for is configured in the Server-side components Properties dialog.

You can check availability of the defined folder by clicking the corresponding button.

Note: The Check button is available only if backup is configured on a single server.

 

Backup file name

Define backup file name. Type backup file name manually or form it using variables. For your convenience {server}, {database}, {backup_type}, {date} and {login} tags are provided. If you want to upload backup file to an external storage it is recommended to use the {date} tag for the backup file to have a unique name.

 

Note: To insert a tag in the field simply click it in the list of Available tags.

 

RadioButton Backup to a single file

Select this option to backup all selected databases to a single file.

 

RadioButton Backup to several files

This option indicates that backup should be split into several files. Splitting the backup can in some cases speed up the backup process.

 

RadioButton Split by size

Indicates that backup file will be split to volumes of the specified size.

 

RadioButton Split by database

Indicates that each database will be backed up into a separate file.