Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jan 13, 2017 at 11:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2017 at 08:36 AM

    Hello Peter,

    I have only 1873559.

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 16, 2017 at 09:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 16, 2017 at 09:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 18, 2017 at 05:52 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded