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

  • April 24, 2013 at 6:15 am

    #1609432

    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??....

    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] 😉