search

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

SP DatabaseBackup: compress not accepted #526

Closed FLeenders closed 1 week ago

FLeenders commented 3 years ago

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 commented 2 years ago

Is this issue still happening?

FLeenders commented 2 years ago

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

olahallengren commented 2 years ago

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 commented 2 years ago

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

olahallengren commented 1 week ago

The server - level 'backup compression default' should not matter here.

In any case, I am not able to reproduce the issue.