{"id":117,"date":"2012-04-20T09:50:04","date_gmt":"2012-04-20T08:50:04","guid":{"rendered":"http:\/\/www.darrencoupland.com\/blog\/?p=117"},"modified":"2012-04-20T10:07:51","modified_gmt":"2012-04-20T09:07:51","slug":"update-to-ola-hallengrens-sql-server-maintenance-solution-available-support-for-sql-server-2012","status":"publish","type":"post","link":"https:\/\/www.darrencoupland.com\/blog\/2012\/04\/update-to-ola-hallengrens-sql-server-maintenance-solution-available-support-for-sql-server-2012\/","title":{"rendered":"Update to Ola Hallengren&#8217;s SQL Server Maintenance Solution available &#8211; Support for SQL Server 2012"},"content":{"rendered":"<p><strong>New Version Available<\/strong><\/p>\n<p>A new version of the SQL Server Maintenance Solution by Ola Hallengren&#8217;s\u00a0is now available. The new version supports SQL Server 2012.<\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n<p>&nbsp;<\/p>\n<p>You can read more about the most recent version of the solution at<br \/>\n<a href=\"http:\/\/ola.hallengren.com\/versions.html\" target=\"_blank\">http:\/\/ola.hallengren.com\/versions.html<\/a><\/p>\n<p>or download it at<\/p>\n<p><a href=\"http:\/\/ola.hallengren.com\/scripts\/MaintenanceSolution.sql\" target=\"_blank\">http:\/\/ola.hallengren.com\/scripts\/MaintenanceSolution.sql<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>New Documentation<\/strong><\/p>\n<p>Updated documentation is now available at<\/p>\n<p><a href=\"http:\/\/ola.hallengren.com\/sql-server-backup.html\" target=\"_blank\">http:\/\/ola.hallengren.com\/sql-server-backup.html<\/a><br \/>\n<a href=\"http:\/\/ola.hallengren.com\/sql-server-integrity-check.html\" target=\"_blank\">http:\/\/ola.hallengren.com\/sql-server-integrity-check.html<\/a><br \/>\n<a href=\"http:\/\/ola.hallengren.com\/sql-server-index-and-statistics-maintenance.html\" target=\"_blank\">http:\/\/ola.hallengren.com\/sql-server-index-and-statistics-maintenance.html<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><br \/>\n<\/strong><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>New Version Available A new version of the SQL Server Maintenance Solution by Ola Hallengren&#8217;s\u00a0is 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. [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5],"tags":[20,19,60,7,21],"class_list":["post-117","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-indexing","tag-maintenance","tag-sql-server","tag-sql2k12","tag-statistics"],"_links":{"self":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/comments?post=117"}],"version-history":[{"count":0,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/117\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/media?parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/categories?post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/tags?post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}