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

Ola Hallengren has updated his SQL Server maintenance scripts with several new features:

  • Rebuild and reorganize partitioned indexes on the partition level in IndexOptimize. Just set the new parameter @PartitionLevel = ‘Y’.
  • Exclusion of indexes on read-only filegroups in IndexOptimize.
  • Use LiteSpeed compression in DatabaseBackup. Just set the new parameter @BackupSoftware = ‘LITESPEED’.
  • New feature to run the stored procedures without executing the commands. Just use the parameter @Execute = ‘N’.
  • The solution now works on all builds and editions of SQL Server 2005 and SQL Server 2008

Well worth checking out.