DATABASE TUNNING - Maintenance Plan (SQL SERVER 2005)

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….



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



Set Update Data optimization information.



Set Schedule for DB Maintenance plan.






Here, specify the database backup plan.



Select path for reports.






Now the DB Maintenance Plan is complete.