Post reply

How to find initial size of the database file and log file in sql server?

  • February 18, 2010 at 4:52 am

    #74217

    For SQL Server 2000, i want to find the initial size of the database file and the transaction log file. How do i find it?

    In the enterprise manager-->DB properties the initial size label is misleading, it shows the current size of the db, but not the initial size.

    I tried searching for answers on google and this forum but did not find anything.

    Regards,

    Ashish

  • 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

  • August 21, 2012 at 6:49 pm

    #1528415

    In views\systemviews for your database there is a sys.sysfiles view that contains that information.t in SQL Server 2008. Previous versions I'm not sure about.

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

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