tag:blogger.com,1999:blog-6894552.post2755122769333893025..comments2010-12-24T08:29:54.025-08:00Andrew Arnotthttps://profiles.google.com/114635397638720587251noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-6894552.post-8126474127870157442010-12-24T08:29:54.025-08:002010-12-24T08:29:54.025-08:00

Warning: Clearing the transaction log with TRUNCATE_ONLY will break your backup chain needed for FULL recovery. A FULL database backup should be executes right after truncating the logs.<br /><br />Source: http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/9997e75e-f126-4901-9379-de540a708ec9#352c6a1d-1866-4737-ada4-7eeff91cbcda

Matthiashttp://www.blogger.com/profile/16004417358136188295noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-38545339290759640422010-09-16T20:50:23.375-07:002010-09-16T20:50:23.375-07:00

Thank you :)

Lordtorohttp://www.blogger.com/profile/11624592092806824863noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-78584235244364495912010-07-16T09:57:29.709-07:002010-07-16T09:57:29.709-07:00

I Like :)

Ibrahimhttp://www.blogger.com/profile/02826760190413677166noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-69912298769814267042010-03-15T09:46:46.107-07:002010-03-15T09:46:46.107-07:00

Thanks Much - This info helped greatly

Walteehttp://www.blogger.com/profile/02999459688275260999noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-72552321555080861292010-02-15T20:33:36.228-08:002010-02-15T20:33:36.228-08:00

Thanks a lot !!!!

Rani Shourahttp://www.blogger.com/profile/13912909434653077634noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-1196795502373074892010-01-15T08:24:45.912-08:002010-01-15T08:24:45.912-08:00

Does this work on SQL 2008?<br />I tried it and got the error:<br /><br />Msg 155, Level 15, State 1, Line 1<br />&#39;truncate_only&#39; is not a recognized BACKUP option.

martyhttp://www.blogger.com/profile/02220727904135739000noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-9378862622199031842009-12-07T21:44:18.061-08:002009-12-07T21:44:18.061-08:00

ํYou solve my problem.<br />Thank you very much.

Pakoroshttp://www.blogger.com/profile/07990250391148039635noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-8365774252121627712009-11-09T08:59:02.043-08:002009-11-09T08:59:02.043-08:00

thanks a lot man

PLAST1Chttp://www.blogger.com/profile/06103948066090256941noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-3736878201890786172009-11-09T08:57:41.917-08:002009-11-09T08:57:41.917-08:00

Thanks a lot!!!

PLAST1Chttp://www.blogger.com/profile/06103948066090256941noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-8946194621893349112009-05-12T10:47:00.000-07:002009-05-12T10:47:00.000-07:00

thanks a Lot Man, I am really happy, trying to email the database since long, but fail due to file size.<br /><br />Muhammad Sharjeel Ahsan

sharjeelhttp://www.blogger.com/profile/08807178322980887908noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-52076154423122127342009-04-07T04:11:00.000-07:002009-04-07T04:11:00.000-07:00

GOD BLESS YOU, DUDE !<BR/><BR/>It's so nice to see the .ldf file just 1.25 MB ! :) thx a lot

ansbloghttp://www.blogger.com/profile/01649798220644029354noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-64254032586147760742009-02-26T04:25:00.000-08:002009-02-26T04:25:00.000-08:00

Wonderful, I'm so happy :)

Göranhttp://www.blogger.com/profile/14313226212270493876noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-25047801811696666992009-02-01T12:38:00.000-08:002009-02-01T12:38:00.000-08:00

so simple so great! bro you saved my life! :D

g1gahttp://www.blogger.com/profile/04661705408267439676noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-40736480013072210112008-08-21T02:02:00.000-07:002008-08-21T02:02:00.000-07:00

awesome, finally someone with the answer i'm looking for...

Sebastienhttp://www.blogger.com/profile/11494952988253115552noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-46343468130917638562008-07-27T17:06:00.000-07:002008-07-27T17:06:00.000-07:00

It's my turn to say : "Thanks, man!" :)

andreirhttp://andreir.wordpress.com/noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-42754207230482625672008-07-01T09:06:00.000-07:002008-07-01T09:06:00.000-07:00

thanx a lot dude

Sandeep K Nhttp://www.blogger.com/profile/06130699401884642473noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-69926338907131973192008-06-29T23:11:00.000-07:002008-06-29T23:11:00.000-07:00

Thank for sharing this SQL. I've been looking for this for a very long time.

Arvinhttp://www.blogger.com/profile/13685385073360711706noreply@blogger.comtag:blogger.com,1999:blog-6894552.post-89181952153196136782008-04-29T09:35:00.000-07:002008-04-29T09:35:00.000-07:00

Great code. Thanks. You saved me 50 GB of my server's hard drive.

Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6894552.post-64359201300374001492008-04-02T10:37:00.000-08:002008-04-02T10:37:00.000-08:00

with 400 users and a report dept that suddenly started "trying things out", I had a log file almost as large as the VM I was running in. <BR/><BR/>Thanks for your blog entry ! You're a lifesaver !

Michael Irwinhttp://www.blogger.com/profile/09839399143423008728noreply@blogger.com