• MODEL database is used for Templet.

    When the user will create the new database it will use the templet of MODEL database to create new database and all setting will be inherited to new database.

    Hence when user will create database if you wish to have all your new database in Full Recovery mode; You need to put the MODEL database into full recovery mode else after the creating database user have to set full recovery.

    No harm in putting MODEL database in Full recovery mode.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."