Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.

Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold and Silver winner in the 2011 and 2010 SQL Server Magazine Awards. I love this tool to perform index maintenance on instances with VLDBs - and the best it's free!

New Version Available

A new version of the SQL Server Maintenance Solution is available. You can now perform striped backups across multiple drives in the DatabaseBackup stored procedure. Simply specify multiple directories in the @Directory parameter; for example:

EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup, D:\Backup, E:\Backup, F:\Backup', @BackupType = 'FULL',
@Compress = 'Y',
@NumberOfFiles = 4

The new version also supports checking the consistency of a database on the file group level and on the table level. This capability is useful when you have VLDBs.

You can read more about the most recent version of the solution at http://ola.hallengren.com/versions.html or download it at http://ola.hallengren.com/scripts/MaintenanceSolution.sql

And now it's up to YOU!

2012 SQL Server Pro Community Choice Awards

The voting for the 2012 SQL Server Pro Community Choice Awards is now open! This year, the Ola Hallengren SQL Server Maintenance Solution has been nominated in the Best Backup & Recovery Product and Best Free Tool categories. So let us VOTE!!!

Please feel free to contact him if you have any questions. And I tell you, Ola will consider it!!!

I wish you a nice  day,
tosc