Data Backup and Recovery Discussions

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

Re: Automatically Deleting SMSQL Reports

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

Re: Automatically Deleting SMSQL Reports

TMADOCTHOMAS

Very helpful, thanks for the tip Jason!

Earn Rewards for Your Review!
GPI Review Banner
All Community Forums
Public