Reg Deletion of Log file

[Former Member]

I am using Ms SQL Server 8.0 as the database for SAP.

I the log file size is large even after shrinking.

Please let me know whetehr deleting the log file directly from backend affect my system

Since i dont want to see the logs. Can i delete it directly.

[Former Member · Accepted solution]

you should define your backup strategy to run the log backup regularly to make the log file size shrinked again.

[Former Member]

Hi Balaji,

If you're talking about production I would recommend you to copy the log to another location and keep it for at least 30 days. Then you can delete it

[Former Member]

deleting log files donot effect the SAP system but i prefer archive these logs and save in safe location if this is a production system

Samrat