Database size B1iF is too big - how can I reduce this

[Former Member]

DB Growth Purge Utility Tool - - Database Size over 35 GB

Hello Experts,

i have a question regarding our B1iF Database Size:

the Cockpit shows these System Resource Information:

I have installed an started the DB Purge Tool:

I have found a query here in the forum which shows the sizes of each Table in B1iF-Database:

In SQL Mgmt Studio I have made a Task for B1iF-Database:

Can you please tell me what I have to do, to reduce the Database Size ?

Thanx for your help.

Best regards

Markus

[edwin_delacruz]

Verify the recovery mode of this database in SSMS, if its on full mode, you can make a backup of the database, change the mode to simple and then shrink the log file.

[agustin_marcoscividanes]

Hi

check the Event Sender configuration, and tick only the databases you use.

Every ticked DB generates information in the B1if database

Kind regards

Agustín Marcos Cividanes

[agustin_marcoscividanes]

Hi

check the Event Sender configuration, and tick only the databases you use.

Every ticked DB generates information in the B1if database

Kind regards

Agustín Marcos Cividanes

[Former Member]

Hello Peter,

I have only 1873559.

Thanks for the info about 1873607. I will check this note soon.

[former_member186605]

Hi Markus, I guess you have seen the full documentation of the purge tool in

https://service.sap.com/sap/support/notes/1873559, right? Another source of Information is 1873607 - Optimized log configuration and database size for integration framework

Hope this helps, Peter