How to delete SQL Maintenance Plan text reports

Posted on Updated on

By default, SQL keeps track of all SQL Maintenance plan operations. And it creates reports about them every time they run in the \MSSQL.1\MSSQL\LOG folder. And overtime, these reports take up a lot of space.

Here are some things you can do to manage these files:

1. First, you can try to move the files to a different drive

– Login to SSMS, and open one of your maintenance plans

– Open ‘Reporting and Logging’ by clicking on the icon to the right of Manage Connections

– Set the new path for the LOG files

2. Another option is to add a task in your maintenance plan to clean up the reports

– Add History Cleanup Task in your maintenance plan (optional)

– Add Maintenance Cleanup Task and set type as ‘Maintenance Plan Text Reports’ and specify the LOG folder path.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s