How do I configure a Maintenance Plan for my database?

Article ID: 220
Category: Database
Applies to: All Versions
Updated: 2019-07-29

When using Microsoft SQL Server with EventSentry, we recommend setting up a Maintenance Plan to continually check integrity, reduce index fragmentation and periodically shrink the database to free up unused disk space.

The following instructions assume the SQL Server Agent is running and Agent XPs is set to enabled. For instructions to enable Agent XPs please see the following article:
https://msdn.microsoft.com/en-us/library/ms178127.aspx

Microsoft SQL Server 2008 R2
- Open Microsoft SQL Management Studio
- Expand Management folder
- Right click Maintenance Plans and select Maintenance Plan Wizard
- On the Select Plan Properties step set the Name to EventSentry
- Set the schedule based on your preferences by clicking Change
- Under Select Maintenance Tasks check the following:
* Check Database Integrity
* Shrink Database
* Reorganize Index
- Continue with Select Maintenance Task Order set with the defaults
- Select the EventSentry database for each scheduled task
- Select Report Options based on your preferences
- Complete the wizard and select Finish