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

By

Posted on Jun 22, 2009 by in SQL Server

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
This entry was posted by and is filed under SQL Server. Tags: backup, index, integrity, maintenance

No feedback yet


Form is loading...