DATABASE TUNING - Maintenance Plan


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