Notifications
Announcements
No record found.
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?
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.
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
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
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 687 Most Valuable Professional
André Arnaud de Cal... 535 Super User 2025 Season 2
BillurSamdancioglu 403 Most Valuable Professional
