Post reply

Can model system database's size ever increase?

  • November 23, 2011 at 12:02 am

    #250998

    Can model system database's size ever increase?

    Thanks

  • November 23, 2011 at 12:09 am

    #1411966

    Yes if someone is adding DB objects into it.

    FYI

    When a CREATE DATABASE statement is issued, the first part of the database is created by copying in the contents of the model database. The rest of the new database is then filled with empty pages.

    If you modify the model database, all databases created afterward will inherit those changes. For example, you could set permissions or database options, or add objects such as tables, functions, or stored procedures.

  • November 23, 2011 at 12:14 am

    #1411967

    Yes as said, if anyone add any objects in model which needs to be there when DBA create a new DB.

    In SQL 2008 onwards, the recovery model is full, which you can change it to simple in DEV and TEST environments, production environments, you can keep it as 'Full' provided, you setup a proper backup strategy for Log backups. Otherwise, you will never know that, when Log get full.:-)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply