Skip to Content
0
Former Member
Aug 22, 2007 at 06:55 AM

Reducing LOG file size or defining new dirve.

14 Views

Hi, We are working with SAP ECC6.0 with MS SQL SERVER 2005,As per the details mention below our hardisk hasno free space and we added new harddrive as D:, pls let me know how to reduce the log file size or defining

new harddrive for datafile and log file.

In ST04 we see the

Total data size as: 296,436 MB

data free space as: 106,944 MB

Total Log Size (MB) 140,245

Log Free Space (MB) 3,444

Available Hardrive free space

Drive C: 4GB

Drive E: 1.52GB (SAP installed drive)

Drive D: 170GB (Additional Drive)

Data files and log file size (Note: SA4 is system id)

SA4DATA1.MDF 38GB

SA4DATA2.MDF 36GB

SA4DATA3.MDF 36GB

SA4LOG1.LDF 144GB (Growing faster)

Thanks in advance

balan.