sql-server-maintenance-solution icon indicating copy to clipboard operation
sql-server-maintenance-solution copied to clipboard

SP DatabaseBackup: compress not accepted

Open FLeenders opened this issue 4 years ago • 4 comments

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.

FLeenders avatar May 12 '21 06:05 FLeenders

Is this issue still happening?

olahallengren avatar Dec 31 '21 18:12 olahallengren

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

FLeenders avatar Jan 01 '22 17:01 FLeenders

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.

olahallengren avatar Jan 01 '22 18:01 olahallengren

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>

FLeenders avatar May 07 '22 16:05 FLeenders