Sugesh Kumar (2/27/2008)
Put the model database in simple recovery model. Also don't create any table in the model database and no transaction there.
Just be aware that by doing this any new databases you create on that server will be in Simple mode as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question