How do you use cloud databases? Take the survey.
Options
we need to wipeout the old data so our mdf file size decrease
imran140
Posts: 1 New member
I have created an EC2 AMI from the old SQL Monitor server, created a new server, and deleted old logs and entries and unused old Monitors servers, but my MDF file does not decrease the size.
I want to delete all monitor servers and logs on the SQL monitor server and then re-add some servers on that which we have to monitor.
I want to delete all monitor servers and logs on the SQL monitor server and then re-add some servers on that which we have to monitor.
Tagged:
Answers
Hi @imran140
If you have Monitor up and running you should be able to access the configuration and modify data retention for various areas of the program.
By setting it to 1 day and removing the non-required servers from being monitored I would expect their data to be purged and reduce used storage on your system
This is accessed through Configuration > Data Management
You can also see how much space is being used by different areas of SQL Monitor here too so you can tailor how long you store different bits of data.