Skip to Content
0

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

Jan 13, 2017 at 10:06 AM

297

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Peter Hartwich
Jan 13, 2017 at 11:25 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 16, 2017 at 08:36 AM
0

Hello Peter,

I have only 1873559.

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

Share
10 |10000 characters needed characters left characters exceeded
Agustin Marcos Cividanes Jan 16, 2017 at 09:45 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Agustin Marcos Cividanes Jan 16, 2017 at 09:45 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 18, 2017 at 05:52 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded