Im not exactly sure what is considered for a "good" plan but on mine. I just reogrinize the data and index pages and then backup the db and log. I skip the check database integrity option.

Eric

>What things should be done in a good maintenance plan for a database? Basically I'm looking for a list of the "must" do in the maintenance plan and a list of "optional" things to do for a maintenance plan to run either daily, weekly, or monthly.
>
>Thanks.