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

No feedback yet
Leave a comment

Your email address will not be revealed on this site.
PoorExcellent
(Line breaks become <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)
Trackback address for this post

http://www.insidesql.org/blogs/htsrv/trackback.php?tb_id=338