Ola Hallengren, who I've had the pleasure to meet while speaking in Denmark, has a great set of scripts for index optimization, database intregrity checks, and database backup which he describe in the SQLMag article at http://www.sqlmag.com/Articles/ArticleID/100178/100178.html.

Ola has been very active in updating and maintaining the scripts, such as amendments to the backup portion of the scripts to support popular third-party backup solutions. Ola has made updates as recently as last month. Find his script, FAQ, and documentation at http://ola.hallengren.com.

Cheers,

Kevin

Twitter at kekline