Reducing LOG file size or defining new dirve.

[Former Member]

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 😧 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.

[Former Member]

Using shrink from sql query or sql enterprise manager can be able to reduce the file size.

[Former Member]

Hi Balan,

your situation looks a little scarry to me. Why do you have such a big transaction log? Are you backing up the log on a regular basis (like every 30 minutes or so)? You must if you have the recovery model 'full'. If you do so, check with DBCC OPENTRAN what causes the log to grow to such a size.

Please have a look at SAP 'Note 363018 - File management with SQL Server'. That should answer your questions concerning the file management.

Regards,

Sven

[rafal-olechowsk]

Hi,

You should make a full backup of your database from OS level, this will flush data from log file to the data files, then you can shrink your log file by BD tool (Microsoft SQL Server Management Studio).

You can add new data file (placed on your 😧 harddrive) to the data group by the same DB tool.

Hope this helps,

Rafal Olechowski