I was working on a SQL Server installation this week when I was reminded of an excellent maintenance solution for the database server. Ola Hallengren’s database maintenance solution is a package of scripts based on Microsoft’s best practices for backing up, checking integrity, and optimizing indexes for databases.
It is easy to implement for the savvy SQL user. The scripts are also flexible enough to allow for more granular configuration of the maintenance job.
If you haven’t tried it, I strongly recommend that you review it at a minimum. You will be glad you did. http://ola.hallengren.com/