New updated maintenance plan scripts from Ola Hallengren

Great to see our buddy Ola Hallengren has created an updated version of his database maintenance scripts. Many people use these in place of the database maintenance plans that ship with SQL Server.

Here’s the updated info from Ola and the best part is that they continue to be free:

New Version Available

A new version of the SQL Server Maintenance Solution is now available. The new version supports SQL Server 2012.

One new feature in SQL Server 2012 is AlwaysOn Availability Groups. This feature supports multiple replicas of a database. You can back up any replica and define a preferred backup replica.

SQL Server 2012 also supports online rebuilding of indexes with varchar(max), nvarchar(max), varbinary(max), or XML data types or large CLR types. The new version of the SQL Server Maintenance Solution makes use of this capability.

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

New Documentation

Updated documentation is now available at

http://ola.hallengren.com/sql-server-backup.html

http://ola.hallengren.com/sql-server-integrity-check.html

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

If you have been linking to the old documentation web page, please update your links to point to these new URLs.

2012-04-22