I have made a solution for backup, integrity check and index optimization 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 documentation is available on my website, http://ola.hallengren.com. The solution was last updated 15 August 2010. The solution is free to use and modify. Please feel free to contact me if you have any questions.
Ola Hallengren
http://ola.hallengren.com