Data Backup and Recovery

Automatically Deleting SMSQL Reports

TMADOCTHOMAS

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

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

Very helpful, thanks for the tip Jason!

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public