Post reply

Initial size of files

  • August 18, 2011 at 6:50 am

    #243352

    Hi,

    I have a question about the initial size of database files. I currently have a databse withe the following sizes

    MDF: 1.5gb

    LDF: 1gb

    MDF Initial size: 500mb

    LDF Initial size: 1gb

    What I am wondering, is when SQL restarts, from say a weekly reboot, will those initial size values be changed to reflect the current size of the database files, or will those files have to grow to accomodate the amount of data in them?

    I think it is the former, but need to be sure.

    Thanks,

    Bodsda

  • August 18, 2011 at 8:33 am

    #1370158

    Initial size will not be changed. If the database contains the data less than the intial size, the size will be the initial size. As the database grows beyound the initial size, mdf and ldf file size grows.

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • August 18, 2011 at 11:01 am

    #1370260

    But what if the size of the data is bigger than the initial size?

  • August 18, 2011 at 1:48 pm

    #1370363

    It will grow by the amount you set it to grow.

    May be the following post will help you understand it. I had similar question and friends here have helped me to understand.

    http://www.sqlservercentral.com/Forums/Topic1156927-391-1.aspx

    Have a great day!

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

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