« SQL Server 2008 Failover Clustering
Cumulative update package 4 for SQL Server 2005 Service Pack 3 »

SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization

Ola Hallengren, with his wonderful SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - made some updates to his maintenance scripts:

  • Support for printing of commands without executing them. Set the new parameter @Execute to 'N' to use this feature. Please note that you need the latest versions of DatabaseBackup, DatabaseIntegrityCheck, IndexOptimize and CommandExecute to use this feature.
  • Changed behaviour in DatabaseBackup when deleting old log backups. In the new version it doesn't delete any log backups that are newer than the latest full or differential backup.

CU
tosc


Qui tacet, consentire videtur

backup, index, integrity, maintenance
SQL-Server 2005, SQL-Server 2008, TSQL
 Print article This entry was posted by Torsten Schüßler on 2009-06-22 at 08:37:28 . Follow any responses to this post through RSS 2.0.
No feedback yet
Leave a comment

Your email address will not be revealed on this site.

Your URL will be displayed.
PoorExcellent
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)
This is a captcha-picture. It is used to prevent mass-access by robots.
Please enter the characters from the image above. (case sensitive)

You can just use your OpenID to provide your name, e-mail and url.

Trackback address for this post
This is a captcha-picture. It is used to prevent mass-access by robots.
Please enter the characters from the image above. (case sensitive)