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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

YE Close fails because Log File is too large

(0) ShareShare
ReportReport
Posted on by 4

I can't close my year because the system keeps telling me the log file is too big.  At first I thought it was the drive size, but I expanded that and I still get the error.

My database is set to Full Recovery Mode - & and I made a full backup before trying to close.

Any suggestions?

Categories:
I have the same question (0)
  • Leng Papio Profile Picture
    855 on at

    That error is not a usual error in GP yec; it is most likely an issue on your SQL log file... Have your sql or db guy check on it.

  • Robert Yao Profile Picture
    492 on at

    Hi John,

    If you have a full backup, I would recommend you to change from Full to Simple recovery method, truncate the ldf file, try to close the year again, if successful, then change the recovery from Simple to Full again.

    Good luck.

    Rob

  • Gavin Profile Picture
    2,510 on at

    Hi,

    You'll need to make sure you have enough disk space to transfer the contents of GL20000 to GL30000 as per Microsoft article : KB - Year-end closing procedures for General Ledger in Microsoft Dynamics GP

    You can use SP_SPACEUSED 'GL20000' to find this out.

    The key thing is the transferring of the data to GL30000 is likely performed in one SQL transaction, which will be fully logged, which is why the SQL log will be growing and filling (this will happen in SIMPLE recovery as well) so ensure you have this space for the SQL log file to grow as well. You could temporarily create another SQL log LDF file on another drive that has lots of space while the year end runs. Then, when the year end completes, go through the process of removing the additional LDF file you created. (there's plenty of articles out there on how to do this)

    I hope this helps and you manage to run your year end :)

    Thanks

    Gavin

  • Community Member Profile Picture
    on at

    Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Looking for the same issue. Bumped into your thread.

    alaskasworld

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 510 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 399

#3
Adis Profile Picture

Adis 251 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans