As long as there is space on any one of the files the
database will keep growing. However, when all the files
are full you will get an error that the database file is
full.
HTH

>-----Original Message-----
>We have a SQL 7 database with 3 data files in the primary
filegroup.
>The files have all been allocated 65GBs each and set for
unrestricted
>file growth in 500MB increments. There is plenty of
space on the
>drive where these files are. The question is what will
happen if
>these files all consume 65GBs? Will the files grow
beyond the 65GBs
>even though that is all of the space that has been
allocated to them
>even thought they are set for unrestricted file growth?
>Two of the files have all most reached the allocated
space but one is
>14GBs away. Will the database grind to a halt or
continue to grow?
>
>Thanks,
>Greg
>.
>

Report this post to a moderator