Home Forums SQL Server 2005 Administering Read transaction log file RE: Read transaction log file

  • April 24, 2013 at 10:42 pm

    #1609771

    durai nagarajan (4/24/2013)

    vinu512 (4/24/2013)

    GilaMonster (4/24/2013)

    Simple recovery = log truncated on checkpoint, meaning it'll get overwritten when the log wraps around.

    Thanks, so in simpler words it means I cant get the data back...right???......All I can do now is to set the recovery model to FULL so that something like this doesn't happen in future...right??....

    yes, in addition to it sechdule transaction log backup (as per your need) so that log size will be in control and recovery to the nearest is possible.

    Thanks for the tips Durai.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉