October 6, 2014 at 5:09 pm
Good day, eh.
We have a couple SQL Server 2008 R2 servers on which our Maintenance Plan Logging and Reporting log files are not being created for our backup jobs. The problem is also on a couple of our 2012 servers. The folder path is legit and writable to SQL Server so that's not the issue. These servers are up to date with the appropriate service packs.
At the moment, we are experiencing sporadic Transaction Log backup failures on 2 of these servers and the error message says to check the log file but the log files are not being created. Recently another backup sub-plan was added to one of the Backup Maintenance Plans. The log files for that sub-plan are now being created within the folder in question, but the other 3 backup sub-plans within the Maint Plan are still not being logged.
Any idea on the reason for this behavior? I need to view these log files to troubleshoot errors.
Cheers,
Bob.
February 19, 2015 at 6:52 pm
I did eventually find a solution to this issue: the Logging and reporting option needs to be set up before the Maintenance Plan tasks are created. What I had to do was to delete the task(s) in the Maintenance Plan, make a minor change to the Logging and Reporting options and save them, and then recreate the tasks. Once that was done, the log files were created by the system.
Fortunately, we are switching out the Maintenance Plans with SQL scripts so should not have this problem again.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply