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 4, 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 9, 2013 8:07 AM
Points: 1,220, 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 4, 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, November 20, 2014 11:11 AM
Points: 58, Visits: 296
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 @ 11:57 AM
Points: 5,888, Visits: 13,062
in the log directory created by SQL under your chosen installation path

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

Post #1465403
Posted Thursday, May 22, 2014 9:02 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 23, 2014 11:22 AM
Points: 99, Visits: 23
I have an issue with the logging. The output is trying to write to K:\\Backup_ProdI1\\Result_Files\\MaintenancePlan.txt, even though I have selected K:\Backup_ProdI1\Result_Files\MaintenancePlan.txt as the output path through the Reporting and Logging dialog window. Why is SQL adding the extra "\" at each directory marker and more importantly, how do I get rid of it so my backups start getting logged?

PS... this is SQL 2012.
Post #1573618
Posted Thursday, May 22, 2014 9:53 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
MonkeyPaw2u (5/22/2014)
I have an issue with the logging. The output is trying to write to K:\\Backup_ProdI1\\Result_Files\\MaintenancePlan.txt, even though I have selected K:\Backup_ProdI1\Result_Files\MaintenancePlan.txt as the output path through the Reporting and Logging dialog window. Why is SQL adding the extra "\" at each directory marker and more importantly, how do I get rid of it so my backups start getting logged?

PS... this is SQL 2012.


That is added due to the nature of maintenance plans and the XML behind the scenes.
It should have no impact on writing out to the log file so long as the path exists and permissions are in place for that path.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1573647
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse