tag:blogger.com,1999:blog-9075786158122089104.post3607124142333201949..comments2023-10-23T19:47:51.926+05:30Comments on SQL-Server Blog of Ritesh Shah --Fight the fear of SQL with SQLHub.com: SQL Server Truncate Transaction Log scriptRitesh Shahhttp://www.blogger.com/profile/09562656548324468450noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-9075786158122089104.post-67046795038019615032010-11-21T11:41:18.671+05:302010-11-21T11:41:18.671+05:30Hey thanks... worked from 40GB to 25 MB... in seco...Hey thanks... worked from 40GB to 25 MB... in seconds.Rizwan Naikhttps://www.blogger.com/profile/10903394717905974789noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-27009088602065482822010-11-21T11:40:59.908+05:302010-11-21T11:40:59.908+05:30Hey thanks... worked from 40GB to 25 MB... in seco...Hey thanks... worked from 40GB to 25 MB... in seconds.Rizwan Naikhttps://www.blogger.com/profile/10903394717905974789noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-78186936936829766272010-11-21T11:40:33.094+05:302010-11-21T11:40:33.094+05:30Hey thanks... worked from 40GB to 25 MB... in seco...Hey thanks... worked from 40GB to 25 MB... in seconds.Rizwan Naikhttps://www.blogger.com/profile/10903394717905974789noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-79802338265825347192010-11-21T11:38:33.304+05:302010-11-21T11:38:33.304+05:30Thanks it helped me too to reduce 40 GB log to 25 ...Thanks it helped me too to reduce 40 GB log to 25 mb.... Thanks a lot.Rizwan Naikhttps://www.blogger.com/profile/10903394717905974789noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-73256980174103088322009-03-30T19:21:00.000+05:302009-03-30T19:21:00.000+05:30you are welcome.you are welcome.Ritesh Shahhttps://www.blogger.com/profile/09562656548324468450noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-73637508785161952652009-03-30T19:19:00.000+05:302009-03-30T19:19:00.000+05:30Thank you. I had an 18GB transaction log that gre...Thank you. I had an 18GB transaction log that grew by ~1GB per day (netflow statistics from a router). <BR/><BR/>Your script allowed me to go from 18GB to 3.4MB.Anonymousnoreply@blogger.com