Quick Maintenance & Backup for MS SQL
SQL server information

This stage of the wizard shows information about the version and edition of the SQL server, as well as the currently installed QMB license.

You can add an arbitrary comment in the Notes field.

If the current version of the SQL server supports backup compression, the form will have an Enable backup compression option (corresponding to the backup compression default parameter on the SQL server). When enabled, all database backups will be compressed by the SQL server.

There are some limitations for compressed backup files. For example, a backup file cannot contain compressed and non-compressed sets of backup copies. Also, you should bear in mind that you won’t be able to restore a compressed backup copy on an SQL server that doesn’t support backup compression, such as SQL Express, for example. More details can be found in MSDN.
See Also