Is it Okay to Delete Transaction Log????

[apphog]

Hello People,


is it okay to delete old transaction log file, becasue these files are taking too much space in HD.

if it's possible, please let me know how can I do it step by step.

thanks

 

[tvergonet]

They should purge when you run a backup. Check to see if your backup job is working. I had the same problem when mine failed.

 

[MarkSe]

NEVER delete transaction logs as you may put your IS into an unrecoverable state. Run through a full backup and the logs should be purged. If you are using BAckupExec etc and this is failing test with NtBackup.

Look in the app logs to check if the backup is failing and why (if you are receiving 1018s) then you have a HW problem. Usually RAID controller or the physical disk itself.

NOTE: the 1018 will actually be in the description you will prob see an ESE error 200 - 400 if this is happening.

Mark