RE: YE Close fails because Log File is too large
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