Microsoft has released a database maintenance guide for administrators.

Its worth a read and easy to follow. Only a few pages long, it details a step by step process on creating a SharePoint SQL Maintenance Plan.

Download it here.