I am getting the following error on a particular server only. Have this utility running fine on 2 other servers. The issue seems to be with the reporting as once the reporting is disabled all works fine.
Msg 50000, Level 16, State 1, Procedure expressmaint, Line 304
Error creating log file
If I set @report to 0 all works fine. Any Ideas? The folders exist and are accessible.
@database = 'ALL_USER',
@optype = 'DB',
@backupfldr = 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup',
@reportfldr = 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Report',
@verify = 1,
@dbretainunit = 'days',
@dbretainval = 1,
@rptretainunit = 'weeks',
@rptretainval = 1,
@report = 1