This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 10%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
We are using DB Cluster and FC to provide volume for it. We are deploying Monitoring Appliaction in our system
Every day, when we add a device and monitor it syncs a lot of logs on the MS SQL 2019 DB (Note that for MSSQL we also built HA, including 2 DB with AG and listener)
To deal with it in the short term we have to truncate and delete logs manually
The process for it is that we have to remove the AG (Available Group) (all DB had added to AG) and change it to simple mode (from full mode). By doing that we can shrink the log to save
more volume. After cleaning the log we add it to AG again.
Is there any way that we can create a job or scripts to schedule and automate that job instead of doing it manually? If you guys have it, please guide and help us
Thanks and Best Regards
Is there any way that we can create a job or scripts to schedule and automate that job instead of doing it manually?
If 'that job' means remove the AG --> change it to simple mode --> shrink the log -->add it to AG again, as far as I know, there is no such scripts.
Hm, what's wrong with simply backing up the transaction log? And doing that often enough so that the transaction log does not grow out of bounds.
What you describe is, permit me to say so, complete insanity. What's the point with having a database in an AG, if you take it out of the AG every day? Better in that case to take it out of the AG for good and set the database to simple recovery.
Hi, thanks for your opinion. The reason why I had to remove it from the AG change it to simple mode, and then put it back in is because that way we can shrink more logs and more available volume. We are deploying a monitoring system for a big bank with a huge amount of resources (Devices, Applications, ...) and it syncs a lot of transaction logs per day. I'm asking for help if there is a way to create a job to schedule it to clean the logs file in the Database or another solution that could help us save time. We are using OpManager from Manage Engine to monitor the whole system (which have over 2,300 devices)
I did not ask why you are removing it from the AG. I asked why are you putting it back into the AG?
What exactly do you mean with "sync the logs"? What logs? Log tables? Or the transaction log itself?