Post reply

Reporting database for an ERP system

  • December 9, 2005 at 9:38 am

    #188668

    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

    #608726

    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

    #608763

    Thanks,

    I reset the database to "simple".

  • August 14, 2015 at 4:56 am

    #1819995

    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

    #1999408

    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