Drop Transation Log Files in SQL server

[Former Member]

Hi friends,

I am useing sql server 2005 , in my databse transation log file is increased up to 20 GB ,so i am adding one more transation file , so i want delete pervious unused transation log file,so what is the procedure for drop the transation log file from my databse any one can help me....

Thanks,

Nageswar

[Former Member · Accepted solution]

Hi,

Check SAP Note 363018

also check

regards,

kaushal

[Former Member]

20 GB?

How often are you backing up the transaction log?

I would recommend backing up the log at least every 30 minutes if not every 15. 20 GB of data is a lot of transactional information to lose should yoru system crash. Most small SAP systems don't generate 20GB of logs in two weeks time, and losing two weeks of data could be catastrophic.