MSSQL2019 with Always On Availability How to Truncate?

Question

Hello everyone,

I am using MSSQL2019 with Always On Availability setup.
and I facing my DB_log is usage higher and want to truncate all DB Log.

how I able to using SQL Job Agent with scheduler taks to clean all the DB log?

Do have any script can share or how I able truncate it?
I try some script is not able run with Always On Availability!
appreciation for your help.

Answer 1

Hi @Kelvin Shee ,

Welcome to Microsoft Q&A!
Please refer to my answer i post in this thread: https://learn.microsoft.com/en-us/answers/questions/748048/alwayson-hadr-1.html
For databases with a full or bulk log recovery model, the system truncates the transaction log only after a successful backup of the transaction log.
So you'd better create an maintenance plan to do the backup.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I try backup transaction log and then I doing shrink log

some DB log is already deduct, but some DB the log file size is still same?

may I know what happen for the DB log after I shrink but the file size is still same?