• Put the model database in simple recovery model. Also don't create any table in the model database and no transaction there.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com