• Yes model database acts as a template for new databases to be created. so having the model database set to simple has to be done only when needed.

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