THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

The Bit Bucket (Greg Low): IDisposable

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

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.

Published Sunday, April 22, 2012 6:21 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Lily said:

Good informations and links, thanks :).

April 22, 2012 3:01 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement