Data Backup and Recovery

Automatically Deleting SMSQL Reports

TMADOCTHOMAS
2,601 Views

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.

2 REPLIES 2

jason_lempka
2,601 Views

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

TMADOCTHOMAS
2,601 Views

Very helpful, thanks for the tip Jason!

Public