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

I'm sure, that's exactly what Albert Einstein meant in his quote:"Try not to become a man of success but rather to become a man of value", Ola Hallengren becomes a man of value - with his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts.

He made some updates to the maintenance scripts:

  • Support for selecting all databases; @Databases = 'ALL_DATABASES'.
  • A database that is in single user mode can only be accessed by one user at a time. The new version has a check for this.
  • Check in DatabaseBackup that database names are unique in the file system.
  • New time limit parameter in IndexOptimize. Set @TimeLimit to for example 300 not to start execution of new commands after 300 seconds. (Ola, that's what I exactly meant! :-))

CU tosc