Pages

Saturday, December 5, 2009

Ola Hallengren’s Maintenance Solution Updated!

Over the past week, I have traded e-mails with Ola Hallengren in Sweden regarding his highly regarded SQL Server maintenance scripts. 

I made a suggestion that he include a parameter for the Litespeed @compressionlevel parameter.

Today, he updated his scripts to add this parameter! 

His announcement to me follows.

Hi Ronald,

I have now released a version with this feature.

EXECUTE dbo.DatabaseBackup @Databases = 'AdventureWorks',
@Directory = 'C:\Backup',
@BackupType = 'FULL',
@BackupSoftware = 'LITESPEED',
@Compress = 'Y',
@CompressionLevel = 7,
@Verify = 'Y'

http://ola.hallengren.com/Versions.html

Please try it out.

Best regards

Ola

My intention is to use Ola’s scripts as the core of our updated maintenance routines. 

Our current routines were written back in 2002 and aren’t using the latest syntax.

Many thanks to Ola Hallengren for implementing my suggestion so quickly!