SQL Server Maintenance Plan Recommendation: Use Ola Hallengren's Pre-Built Scripts
This set of maintenance plans has been recommended by SQL Pros one too many times to ignore. If you have a rather standard environment, check out Ola Hallengren's scripts for SQL Server Backup, Integrity Check, Index and Statistics Maintenance. Actually, if you have a pretty high end environment, you can explore it as well. Ola states:
I have developed a solution for backup, integrity check, index and statistics maintenance in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. The solution is based on stored procedures, functions, sqlcmd and SQL Server Agent jobs. The solution has been designed for the most critical enterprise environments and it is used in many organizations around the world. The solution is recommended by SQL Server community experts, it was awarded Gold in the SQL Server Magazine Awards 2010 and it is free.