SQL native compression and no sqlbackupandftp compression, is it possible?

How it works
1

If we enable backup compression in sql server as server default, and disable compression in sqlbackupandftp, will it work?

Will sqlbackupandftp perform the sql backup with compression?

2

Hi Max_Favilli,

If you disable the compression, the backup will be performed without the compression. If you prefer to perform backups with native SQL Server compression then please go to the “Backup options” section and choose the needed value for the “SQL Server backup compression” option. If you set an option to “Default” then SQLBackupAndFTP shows you the value that is set in your SQL Server.

SQLBackupAndFTP
SQLBackupAndFTP715×475 26.1 KB

If you have any other questions, please let us know.

Thank you.