December 9, 2005 at 9:38 am
Hi,
I've created a reporting database that pulls data from the ERP system using DTS packages. On the reporting database the statistics are 2488 MB for data files and 44563 MB for log files. My question is why is the log file this big and what are possible strategies to managing this log file. Keep in mind that this is a reporting database and I don't need to record every process.
Thanks,
Joe
December 9, 2005 at 9:46 am
You are probably not backing up the log or truncating it on the reporting database. Everytime you add data, you're adding to the log.
If this isn't critical data and you can stand to lose some of it, then I'd set the database to "simple" mode in the options. This will truncate the log every few minutes and it shouldn't grow very large.
Not sure of how large your loads are, but the largest loads will determine the size of your log. You can always setup a job on off hours to shrink it if need be.
December 9, 2005 at 10:39 am
Thanks,
I reset the database to "simple".
August 14, 2015 at 4:56 am
ERP software companies have a privilege for being ambitious to pull off.
The software, as an enterprise-wide distribution, flourish on many parts of your organization and involves many stakeholders.
July 30, 2018 at 1:13 am
May I consider your ideas you are offered to your post. They are really convincing and will certainly work. Thanks for the post.
NFC payment apps
July 6, 2021 at 12:45 pm
This was removed by the editor as SPAM
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply