Database maintenance for Office SharePoint Server 2007 (white paper)

This white paper provides information and guidelines for maintaining the databases that host Microsoft SharePoint Products and Technologies data and configurations. It describes and provides examples of the database maintenance tasks that we recommend when using SharePoint Products and Technologies.

http://technet.microsoft.com/en-us/library/cc262731.aspx