SP DatabaseBackup: compress not accepted
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.
Is this issue still happening?
I dont know, i switched off the check in the procedure.
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.
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 https://github.com/olahallengren/sql-server-maintenance-solution/issues/526#issuecomment-1003599414, 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>