Skip to Content
Former Member
Oct 27, 2010 at 02:34 AM

BPC log files very large


Hi All,

our BPC log files are very large compared to the data files. our

we have separate disks for data and log files:

DATA D:\ = 550GB total

LOG E:\ = 278GB total

D:\ICTSI_BPC.mdf = 5.6GB

E:\ICTSI_BPC_log.ldf = 185GB

is this correct? i have read that Log file should roughly be 25% of the

size of the total amount of data. Example: a 4GB database should have a

1GB log file. How can we adjust the size of the SQL log file?

we are using a multiserver set up, SAP BPC 7 SP04 (32bit)

MS SQL 2008 Server (64 bit)

thanks in advance!