topic Automatically Deleting SMSQL Reports in Data Protection

Automatically Deleting SMSQL Reports

TMADOCTHOMAS — Thu, 05 Jun 2025 05:46:12 GMT

Is there a setting in SMSQL to automatically delete old SMSQL Reports after a certain number of days? I just found out that the previous years' worth of logs are still in the SMSQL directory and the drive is almost out of space. Of course we can just remove the older reports but I would like to automate it if possible.

Re: Automatically Deleting SMSQL Reports

jason_lempka — Mon, 06 Jan 2014 11:16:50 GMT

We never found an automated way via SMSQL to remove older reports, so instead we created a scheduled task which consists of the following command and put it on all of our SMSQL/SME machines:

Forfiles -p "C:\Program Files\NetApp\SnapManager for SQL Server\Report" -s -m *.* -d -30 -c "cmd /c del /q @path"

which removes all files under that path which are older than 30 days. We run it once a day and it prunes the files for us.

Hope this helps!

Jason

Re: Automatically Deleting SMSQL Reports

TMADOCTHOMAS — Mon, 06 Jan 2014 18:47:56 GMT

Very helpful, thanks for the tip Jason!