September 1, 2009 at 8:38 am
I have a database where the Autogrow is set to 200Mb unrestricted file growth. I am aware of the sizing versus unrestricted growth aurgement, but putting that aside, what I would like to understand is the behaviour of the database, when a large import process is run against it.
If an import process is run will and this process causes the database to grow by over 200 Mb will it cause an error, it will the database grow during the import process to accomodate this ?
September 1, 2009 at 8:48 am
The 200MB growth increment will occur when the data file is full. Once the data file hits 100%, it will grow by 200MB and then start filling the data page again. It will repeat this process until your large insert is complete.
If you know when this insert will take place, you should be able to calculate an approximate growth figure based on the data you have in your database already.
I'd get this estimate and grow the file manually to save having to continually grow the file during the insert operation.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply