Skip to Content

CCO SQL Log File Size

Hey experts,

After about 5 months of working with SAP Customer Checkout. The SQL Database log file (.ldf) has grown to a shocking 130GB!

How can I manage the database size? I'm running out of space on the server.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Oct 23, 2019 at 04:12 PM

    This is not a CCO problem, but a DB administration problem.

    You should either:

    • Set the DB recovery model to "Simple", then shrink the log file and keep the DB recovery model as simple, or
    • Keep the DB recovery model as "Full", but run proper and regular data and log backups to keep the log file size at an appropriate size.

    As I said, there's nothing to do on the CCO side, read up on the DB administration topic on MS website and others.

    Regards,

    Joerg.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 16, 2019 at 12:02 PM

    Hi Kevin,
    1 - In the CCO, go to Configuration > Integration > SAP Customer Checkout Manager.


    2 - Check the settings under the Monitoring area and define the Severity according the customer needs. For further information, refer to the documentation below: https://help.sap.com/viewer/71570024ae3843f08a10d68054192d3d/2.0.7/en-US/ae85c1fa725640e1b0832686e215bc51.html


    3- It is recommended to periodically delete these monitoring events, for example, every week, every month, every two months, etc..., to avoid that these information increases the database size. To delete them, in the CCO Manager > go to Monitoring > Delete entries.


    If the content above helps you, please select the answer as “Right Answer”. This helps others to follow and easily locate the content.

    Regards,
    Mateus

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 17, 2019 at 12:23 PM

    Hi Kevin Mwangi ,

    Another option in this case, create a backup and run the Shrink.

    Check if the database size reduced after these steps.
    Regards,
    Anderson

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 17, 2019 at 10:53 AM

    Thanks Mateus for your prompt response.

    I deleted the monitoring entries to only be left with 472 of the past 2 weeks. The database size has not reduced and keeps growing. I'm going to raise an incident for this.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 18, 2019 at 07:43 PM

    What is the recovery mode of that SQL Server DB? That sounds like log files growing forever and thus not being taken care of properly (not getting truncated)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.