First of all, DO NOT USE MAINTENANCE PLANS for any of this. Try what you find at the following URL
ROFL :-D:-P;-):w00t::cool:
There are situations where (not very flexible) maintenance plans are just fine for backups. Small shops, no 3rd party dependence, etc. Totally agree on index and stats though.
I love Ola scripts.
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]