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...