Reporting database for an ERP system

  • Joe Contreras

    Ten Centuries

    Points: 1231

    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

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714600

    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.

  • Joe Contreras

    Ten Centuries

    Points: 1231

    Thanks,

    I reset the database to "simple".

  • tyler.magentax

    Grasshopper

    Points: 23

    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.

  • ramnivasbugalia

    Grasshopper

    Points: 17

    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

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply