All, I do not like using the native sql server 2005 maintenance plans but rather script out tasks to perform maintenance. I do the following... Backup databases nightly (full) using Redgate. 15 minute t-log backups using Redgate. Defrag any index greater than 30% fragmentation rate every night (the logs...

See notes from BOL: Specifies the index leaf level will be reorganized. This clause is equivalent to the older DBCC INDEXDEFRAG. ALTER INDEX REORGANIZE statement is always performed online. This means long-term blocking table locks are not held and queries or updates to the underlying table can continue...