Thursday, January 8, 2015


If you administer a SQL Server you may use the Maintenance Plan for backup and optimization tasks.  If you do this you may not be aware there are logs created that need to be groomed.
When you create an MP there is a little icon in the top that sets the log file settings.

 
This icon opens the Reporting and Logging window below.

 As part of your MP you want to add a Maintenance Cleanup Task that grooms these files.

Make sure the above folder points to the same place the MP Logging report folder is set to.

No comments:

Post a Comment