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

Maintenance plan log file path Expand / Collapse
Author
Message
Posted Wednesday, June 10, 2009 11:01 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 04, 2012 11:40 AM
Points: 89, Visits: 318
We are performing some disk maintenance. In short, I need to change the path for the maintenance plan log files since this disk is going away. I have changed the path for the Agent logs, but can't find a way to change the default path for maintenance plan log files. Can someone help me out?

thank you,
Tim
Post #732486
Posted Wednesday, June 10, 2009 11:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:07 AM
Points: 1,221, Visits: 2,614
Open the Maintenance Plan In Management Studio and at the very top there is a little icon that looks like two reports (right next to Manage Connections). Click the icon and it will bring up the Reporting and Logging dialog box where you can change the path.

Ken Simmons
http://twitter.com/KenSimmons
Post #732506
Posted Wednesday, June 10, 2009 11:32 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 04, 2012 11:40 AM
Points: 89, Visits: 318
Ken,
You sir are a golden demigod!

Thank you,
Tim
Post #732511
Posted Wednesday, June 19, 2013 2:51 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 18, 2013 11:59 AM
Points: 58, Visits: 290
I have DBCC in the maintenance plan.

Where the DBCC output message log file will be created?
Post #1465391
Posted Wednesday, June 19, 2013 3:27 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:24 PM
Points: 5,847, Visits: 12,580
in the log directory created by SQL under your chosen installation path

---------------------------------------------------------------------

Post #1465403
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse