SP DatabaseBackup: compress not accepted

[FLeenders]

SP databasebackup states 'compress=Y is not allowed'. Well, it works fine. I checked that by removing the check on the compress parameter in the SP. And indeed, backup is 75% smaller.

SQL Server version and edition
ProductVersion: 15.0.4123.1
Edition: 2
EditionId: -1534726760

Version of the script
2020-12-31 18:58:56

What command are you executing?
EXECUTE [dbo].[DatabaseBackup]
@databases = 'RSA',
@Directory = @location,
@BackupType = 'FULL' ,
@verify = 'Y',
@compress='Y' ,
@Cleanuptime = 72,
@Checksum = 'Y',
@LogToTable = 'Y'

What output are you getting?
The value for the parameter @compress is not supported.

[olahallengren]

Is this issue still happening?

[FLeenders]

I dont know, i switched off the check in the procedure.

[olahallengren]

I am not able to reproduce it, with the version and edition that you have.

Could you try to enable the check again? If you get the error, please post the complete output.

[FLeenders]

Hello Ola, sorry for the late reply. It works now. Maybe it did not work because on server level 'compress' was not enabled. Thanks for replying. Regards Frank Op za 1 jan. 2022 om 19:43 schreef Ola Hallengren ***@***.***

…

: I am not able to reproduce it, with the version and edition that you have. Could you try to enable the check again? If you get the error, please post the complete output. — Reply to this email directly, view it on GitHub <#526 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALHBVXK6ZO4RBBT2ADEZCQ3UT5DONANCNFSM44X5ES5A> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: <olahallengren/sql-server-maintenance-solution/issues/526/1003599414@ github.com>