New Version: SQL Server Maintenance Solution

Ola Hallengren released a new version of SQL Server Maintenance Solution:

The new version has support for backup to Azure Blob Storage.

Here is how it works:

EXECUTE dbo.DatabaseBackup @Databases = ‘USER_DATABASES’,

@URL = ‘https://myaccount.blob.core.windows.net/mycontainer’,

@Credential = ‘MyCredential’,

@BackupType = ‘FULL’,

@Compress = ‘Y’

and with encryption:

EXECUTE dbo.DatabaseBackup @Databases = ‘USER_DATABASES’,

@URL = ‘https://myaccount.blob.core.windows.net/mycontainer’,

@Credential = ‘MyCredential’,

@BackupType = ‘FULL’,

@Compress = ‘Y’,

@Encrypt = ‘Y’,

@EncryptionAlgorithm = ‘AES_256’,

@ServerCertificate = ‘MyCertificate’,

@Verify = ‘Y’

Backup to Azure Blob Storage is available in SQL Server 2012 (SP1 CU2 and later) and SQL Server 2014.

The new version also has some minor bug fixes and improvements.

The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server.