Data Backup and Recovery Discussions


Automatically Deleting SMSQL Reports

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

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!



Re: Automatically Deleting SMSQL Reports

Very helpful, thanks for the tip Jason!

Check out the KB!
NetApp Insights To Action
All Community Forums