search

olahallengren / sql-server-maintenance-solution

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

Added support for specifying the backup compression algorithm #835

Closed olahallengren closed 1 week ago

olahallengren commented 1 week ago

Here is how to use it:

EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup',
@BackupType = 'FULL',
@Compress = 'Y',
@CheckSum = 'Y',
@CompressionAlgorithm = 'MS_XPRESS',
@Verify = 'Y'
EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup',
@BackupType = 'FULL',
@Compress = 'Y',
@CheckSum = 'Y',
@CompressionAlgorithm = 'QAT_DEFLATE',
@Verify = 'Y'