I have made a solution for backup, integrity check and index optimization in SQL Server 2005 and SQL Server 2008. The solution is based on stored procedures, functions, sqlcmd and SQL Server Agent jobs. The documentation is available on my blog, http://blog.ola.hallengren.com.
Please see the code and the documentation.Ola Hallengrenhttp://ola.hallengren.com
To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.
Subscribing to our newsletters gets you:
Steve Jones Editor, SQLServerCentral.com