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