Home Forums SQL Server 2008 SQL Server 2008 - General reasons RE: reasons

  • July 16, 2013 at 10:27 am

    #1632942

    GilaMonster (7/16/2013)

    ramyours2003 (7/16/2013)

    what are the possible reasons for not truncating the log file ?

    There are no good reasons for not truncating the transaction log, unless you want to test what happens when the log runs out of space.

    What about using simple recovery model? Am I confused here?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2