DATABASE TUNNING - Maintenance Plan (SQL SERVER 2005)

The purpose of this article is to describe ways to improve the performance of a database such as by the defragmentation of the data in the database, transaction log removal from a log to make room for incoming records and backup of the database. Also prevention of log errors.


Purpose: Descriptipn of ways to improve the performance of a database such as by the defragmentation of the data in the database, transaction log removal from a log to make room for incoming records and backup of the database. Also prevention of log errors.

Let's Create Maintenance Plan

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



Just follow as per the DB Maintenance Plan Wizard….

Untitled-14.gif

Here, select a specific database or all databases as needed for your DBM plan.

Untitled-15.gif

Set Update Data optimization information.

Untitled-16.gif

Set Schedule for DB Maintenance plan.

Untitled-17.gif

Untitled-18.gif


Here, specify the database backup plan.

Untitled-21.gif

Select path for reports.

Untitled-20.gif


Untitled-21.gif
Untitled-23.gif
Now the DB Maintenance Plan is complete.

Untitled-24.gif