• alex_zilberman (11/19/2012)


    The recovery model is: simple

    also

    I write the statement something like this:

    Backup Database [db name]

    to disk = N'Path to file'

    with init, Name=N'full database backup', skip, stats=10;

    Is this will not truncate the log and if it do , what statement will do work that I need?

    why you are worrying about truncate_log when you are using simple recovery model ?

    log get truncated every time checkpoint occur in simple recovery model . (Please anyone correct me if I'm wrong)

    -----------------------------------------------------------------------------
    संकेत कोकणे