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.