MicrosoftDynamicAX_log too large

(0) Share

Report

Posted on by Community Member

Good day All,

We are running Microsoft Dynamic AX 2012 R3 in our organization from past 7 months. I am experience now that MicrosoftDynamicAX_log file is occupying more space. In 7 pat it’s consume 0.98TB of space and my server is running in low space. How can I reduce or control the size of that log file?

Regards,

---

Imtiaz Latif

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

BorisD 2,826 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hello imtiaz,

I believe you are referring to the SQL Transaction Log for AX. You need to make sure you are backing up the log file so that SQL can reuse space.

If you are already backing the file, you might want to increase the intervals of the backup to more frequent.

You also should have a maintenance plane setup to deal with the size of this file.

If you are not a SQL Admin, my recommendation would be to notify your SQL Admin regarding the log size, so that they can properly setup a maintenance plane and backup.

You can also refer to the link below for additional information.

docs.microsoft.com/.../manage-the-size-of-the-transaction-log-file

A great starting point to build your maintenance plan is here https://ola.hallengren.com/

You can download Maintenance solutions from this link and just make minor adjustments to accommodate your needs.

Hope this helps!

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Dear Mr. Boris Diroo,

Thanks for the answer with detail.

Regards,

---

Was this reply helpful? Yes No
Martin Dráb 239,029 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi Imtiaz, if Boris's reply answered your question, please verify it. Notice "Did this answer your question?" at the top of his reply.

This will make clear that the thread has been resolved and what the answer is.

Was this reply helpful? Yes No