In SQL2000 SP1 I'm using sqlmaint to perform txn log backups and using -Rpt to generate a report. I'm also using -DelTxtRpt to delete old reports. The log backup, the delete of the backup file and the report creation are all working. The report delete is not working. It only fails for SQL2000. It still works fine in SQL 7.0.
Here's a test script I'm running:
EXEC xp_sqlmaint '-S SRV1 -D pubs -BkUpLog \\FILER\SQL\SRV1 -BkUpMedia DISK -Rpt \\FILER\SQL\SRV1\pubs_tlog_rpt.rpt -DelTxtRpt 2minutes -CrBkSubDir -DelBkUps 2minutes'
I've also tried with -HtmlRpt and -DelHtmlRpt but with the same result.
Has anyone used reports and successfully deleted them?
Thanks in advance