web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

AX Transaction log Files Growing 5GB everyday

(0) ShareShare
ReportReport
Posted on by 10

Dear Experts,

hope someone can shed some light, I'm a newbie at this issue, recently out database log grows drastically, we have followed some suggestion on making it simple and shrinking the log file and works, but since our SQL is on high availability i have to remove the DB on high availability and put it back,  it requires the SQL on full recovery and again the log files grows 5gb everyday . hope fully some have been on the same issue than can help to solve the problem before mt space runs out.

I have the same question (0)
  • nmaenpaa Profile Picture
    101,160 Moderator on at

    Do you have database backup and transaction log backup task in use? How often do they run? Do you take full backups?

  • André Arnaud de Calavon Profile Picture
    301,020 Super User 2025 Season 2 on at

    Hi Momonini,

    Nikolaos did point you in the right direction. The backup procedure should be correct. If there is a backup process enabled and there is no place to finalize the backup correctly (e.g. insufficient disk space) the transaction log will not be cleared and will continuously grow until also the transaction log reaches its growth limit or also gets full due to insufficient disk space.

  • Suggested answer
    guk1964 Profile Picture
    10,888 on at

    Th log fie needs to be of a size that reflects the level of transactions and the frequency of the back up. As you have found if you shrink it then it will just grow back and in the process hit performance and leave behind a lot of unwanted VLFs. So shrink is rarely used when there is exceptional update to  the log e.g a one-off  mass data update, or deletion. Back up should clear the log for reuse.

    What version of SQL? How often do you back up the log? What is the equivalent growth in the database size?

    If something this fundamental is not tested and working then its likely other SQL parameters, trace flags,  and maintenance tasks are also not set up correctly so It is worth investing a day with partner that knows what they are doing to review and reset as needed. This is the foundation of your whole system and any improvements (or shortcomings) affecst all users.  

  • MOMONINI Profile Picture
    10 on at

    sir i only take backup files of DB Daily, not the transaction logs .

  • MOMONINI Profile Picture
    10 on at

    thanks for the advise, but i'm really a dummy newbie on this how can i make the proper backup plan for the transaction log?

    apology for the silly question

  • Suggested answer
    Martin Dráb Profile Picture
    237,878 Most Valuable Professional on at

    A good news is that there is great documentation that you can read on-line. Note that it's quite a lot of information and it's super-critical for your client's data, therefore you should pay a lot of attention to it. You may also use additional resources, such as video courses for DBAs.

    When something fails and you need to restore the database, you'll start by restoring the last backup. But because you make a backup just once a day, it would mean losing up to one day of client's business data, which doesn't sound good. Fortunately it's not your only option.

    Because the transaction log contains information about all transactions happened since the last backup, you can apply it again to get into a point just before the failure. Obviously if there was a lot of transactions since the last backup, the file will be large. It also means that the restore will take a lot of time, which isn't good either.

    The way how you can reduce the amount of data since the last backup is making backups more often. As you can see in the documentation I mention above, full backups are not your only option. Typically there are several differential backups between full backups and very frequent log backups.

  • MOMONINI Profile Picture
    10 on at

    i tried following the documentation and it say it should truncate the log files to reduce it but ii doesn't seem to work,. im still reading and watching a lot of DBA fix but all end in simple and shrink method

  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    You should not truncate the log!

    You can shrink it if there's unused quota in the file. You can use the Disk usage report in SSMS (right click your database) to see how much unused space is in your log file. Shrinking can be done in the db options - files, by typing a new size in the size field

  • Suggested answer
    Khushhal Garg Profile Picture
    1,514 on at

    How big is your data file? Can you check your large tables that are growing, you can look at purging/ archiving tables option as well to purge unnecessary growing tables

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans