Error creating log file

Jul 16, 2013 at 12:49 PM
Hi there,

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.

exec expressmaint
@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