Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reg:History of maintenance plan Expand / Collapse
Author
Message
Posted Saturday, April 27, 2013 2:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 7:46 AM
Points: 190, Visits: 474


Hi,
i went to maintenance plan s and want to view the history of that plan. when i opened the history it is taking lot of time to show the results. there is too much history in it. can we limit the number of history files to view.
Post #1447235
Posted Sunday, April 28, 2013 10:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 1:07 PM
Points: 2, Visits: 68
you can apply filter or only check those MP using checkboxes availble for each and every MP
Post #1447336
Posted Monday, April 29, 2013 7:39 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:37 AM
Points: 381, Visits: 358
Here is a great article from SQL Diaries that shows the steps to clean up your maintenance plan.

http://www.sqldbadiaries.com/2011/03/16/clean-up-maintenance-plan-history/
Post #1447520
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse