Log file Full

[Former Member]

my sap server log file is of about 33.5 GB

Pls let me know the Tcode to delete the log file

Also let me know whether i can delete the log file from backend and will this affect the server

[Former Member · Accepted solution]

Hi Balaji,

The log file location is at OS level and you can find out it's location in the transaction code DB02 ex: <SID>LOG1 and it's phsical name : E:\<SID>LOG1\<SID>LOG1.ldf. Goto that location at OS level and take the backup of log file to somewhere.

Regards,

Ashok

[Former Member · Accepted solution]

After taking the backup of the file shall i delete the log file

[Former Member · Accepted solution]

Hello,

Could you please povide more details about log files? is it oracle or any other DB log file or SAP log file (STAT).

Cheers,

-Sunil

[Former Member · Accepted solution]

i am using MS SQL Server . The log file is created by SAP

[Former Member · Accepted solution]

Hello,

Ok, could you please provide us the location of the log file?

Cheers,

-Sunil

[Former Member · Accepted solution]

Yes, delete the log file contents.

- Ashok

[Former Member · Accepted solution]

Deleting log file means

directly deleting the file <SID> LOG1 or any Tcode for the same

[Former Member · Accepted solution]

Hello,

Do not delete any log file you may face problems. You have not cleared my question which I asked you about the log files, could you please provide me the location of the log file? if it is Database log file, then you can shrink it.

Cheers,

-Sunil

[Former Member · Accepted solution]

i am using MSSQL

I dont know whether it is Database log file or not

But i increase teh log file size by logging to MS sQL Server> Right Click Database> Properties

Please let me know whether it is a database log file

I tried to compress but did not work

[Former Member · Accepted solution]

Hello,

Yes, then it mean it is DB log file. You should configure the backup procedure for your DB.

Refer SAP note 1002099 How to shrink the logfile on MSSQL server 2000

Cheers,

-Sunil

[Former Member]

Try with startsapsrv and give details.

[Former Member]

Satish,

what do you mean Try with startsapsrv and give details

Cheers,

-Sunil