SQLMaint reports

Last Post 12 Apr 2002 02:32 AM by Si_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Si_SQL
New Member
New Member

--
12 Apr 2002 02:32 AM
Hi.
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

Simon


Acceptable Use Policy
---