Purpose: To improve the performance of a database, such as defragmentation of the data inside the database and transaction log removal from the log to make room for incoming records and backup of the database.

Let's Create a Maintenance Plan

Select your database from the SQL Server Enterprise Manager and right-click on it ----All Tasks--Maintenance Plan...

Mplan1.gif

Just follow as per DB Maintenance Plan Wizard....
Mplan2.gif

Here, select exact database or all databases as needed.

Mplan3.gif

Set Update Data optimization information.
Mplan4.gif

Set Schedule for DB Maintenance plan.

Mplan5.gif
Mplan6.gif

Mplan7.gif

Here, specify the database Backup plan:
Mplan8.gif

Select path for reports.

Mplan9.gif
Mplan10.gif

Now the DB Maintenance Plan is complete.

Mplan11.gif
Mplan12.gif