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



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


Here, select exact database or all databases as needed.



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.