CCO SQL Log File Size

[former_member294460]

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

[JoergAldinger · Accepted solution]

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.

[former_member578974]

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/ae85c1fa725640e1b0832686e21...

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

[anderson_schmitt]

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

[sa0016187518]

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)

[former_member294460]

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