• shohelr2003 (11/27/2012)


    There is no log backup in our plan. If transaction log grows larger, we just shrink the log file to 1 MB.

    You can consider to change the recovery model to "Simple"

    Note that file growth and shrinking is bad for performance. You should pre-size the files.