Configure optional backup settings
When you configure SQL Server backups with the Microsoft app agent for Application Direct SSMS plug-in, you can specify optional backup settings on the Backup > Options page. All settings on the Options page are optional.
- From the left panel, click Options to specify optional backup settings.
- To perform a checksum operation with the backup and save the information to the backup media, select Perform checksum before writing to media.
- The Microsoft application agent performs another checksum before a restore to ensure that the checksum matches the backup.
- To use a checksum to detect a partial backup or restore state, select Continue on error.
- The SQL Server verifies the checksum by calculating a local result and comparing the result with the stored value. If the values do not match and you encounter errors, you can select this option to continue the backup or restore operation.
- To truncate the transaction logs before a backup, select Truncate the transaction log.
- The Microsoft application agent enables this option if you select transaction log as the backup type.
- To perform a tail-log backup of the database and leave the database in the restoring state, select Backup the tail of the log and leave the database in the restoring state.
- Under Stripes, select Create a striped backup to create a striped backup. You can also specify the number of stripes. If you specify a value greater than the maximum limit of 32, the value defaults to 32.
- To promote backups of SIMPLE recovery model databases to full level, select Promote to full backup.
- SIMPLE recovery model databases do not support transaction log backups. The Microsoft application agent enables this option if you select the SIMPLE recovery model databases to back up, and transaction log as the backup type.
- To omit SIMPLE recovery model databases from the backup, select Skip backup.
- Microsoft application agent enables this option if you select the SIMPLE recovery model databases to back up, and transaction log as the backup type. SIMPLE recovery model databases do not support transaction log backups.
- To check the status of the selected databases and ignore the databases that are unready or unavailable for backup, select Skip databases that cannot be backed up at their current state.
- If the status of the databases is ONLINE, the databases are ready or available for backup.
- If the status of the databases is OFFLINE, EMERGENCY (SINGLE_USER Mode), SUSPECT, RESTORING, RECOVERING, or RECOVERY_PENDING, the databases are unready or unavailable for backups.
- To generate detailed logs, which you can use to troubleshoot backup issues, specify a number between 1 and 9 in the Select a debug level field. The default value is 0 (zero).
- To delete debug logs older than some days, in the Delete debug logs after field, specify the number of days with a number between 1 and 32767 days. The default value is 0 and does not delete any debug logs.
- Regularly deleting debug logs prevents the log folder on the installation drive from becoming too large.
- To specify backup promotion options, select one of the following values from the Backup Promotion list:
- ALL: Enables backup promotion to occur in any applicable scenario.
- NONE: Disables all backup promotion.
- NONE_WITH_WARNINGS: Disables backup promotion but logs a warning when backup promotion would normally occur.
- SKIP_RECOVERY_MODEL: Disables database recovery model change detection. Backup promotion as a result of the recovery model change will not occur, it but backup promotion in other scenarios will still occur.
- SKIP_RECOVERY_MODEL_WITH_WARNINGS: Enables database recovery model change detection, but if a recover model change is discovered, it logs a warning instead of promoting the backup. Backup promotion in other scenarios will still occur.
- To specify advanced backup options, use the Advanced options field to select or type advanced options.
- Separate multiple entries with a comma, for example:
- BUFFERCOUNT=2, READ_WRITE_FILEGROUPS
- The following advanced backup options are supported:
- BUFFERCOUNT=number_of_IO_buffers: Specifies the total number of I/O buffers that can be used during the backup operation.
- READ_WRITE_FILEGROUPS: Backs up only the read/write (active) filegroups within the database.
- To start the backup operation, click Run.