Post reply

restrict file growth what happens when it gets there

  • January 23, 2008 at 5:58 am

    #76881

    I have noticed one my NDF data file is 10980 in size with a limit of 11000. What happens when it gets bigger and hits the limit?

  • January 23, 2008 at 6:36 am

    #770854

    FROM BOL Databases (Database Engine) > Designing Databases > Designing Files and Filegroups >

    Recommendations

    "When you create a database, make the data files as large as possible, based on the maximum amount of data you expect in the database. Permit the data files to grow automatically, but put a limit on the growth by specifying a maximum data file growth size that leaves some available space on the hard disk. This lets the database grow if more data is added than expected, but does not fill up the disk drive. If the initial data file size is exceeded and the file starts to grow automatically, re-evaluate the expected maximum database size. Then, plan accordingly by adding more disk space, if required, and creating and adding more files or filegroups to the database.

    However, if the database is not supposed to expand beyond its initial size, set the maximum growth size of the database to zero. This prevents the database files from growing. If the database files fill with data, no more data is added until more data files are added to the database or until the existing files are expanded.

    "

    If I remember correctly either a) all transactions that would add data are rolled back, or b) your database shuts down to protect the data. Either way you probably want to look at adding more disk

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • January 23, 2008 at 6:40 am

    #770860

    Can't add any more data to tables on that file.

  • January 23, 2008 at 8:47 am

    #770947

    You will get an error when you would like to insert more data. Also, you will see an error in your SQL log.

  • January 23, 2008 at 8:53 am

    #770952

    If the file grows to the maximum it will not grow anymore as stated. And if the file is full of data such that it fills you will get an error as stated. The only real issue is the amount of data involved in the transactions that fail.

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

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