Home Forums SQL Server 7,2000 Administration How to find initial size of the database file and log file in sql server? RE: How to find initial size of the database file and log file in sql server?

  • February 19, 2010 at 7:15 am

    #1121825

    In SQL Server, each new database created is a copy of the model DB.

    This applies to tables, stored procedures, and file sizes.

    So if you want every new DBs to be 100 data / 50 log, set the model db to 100 data / 50 log.

    P