Hi All

I have a db with multiple files in a filegroup, one file on a disk of it's
own. (one disk is larger than the other). Currently sqlserver is distributing
data on each disk equally so that one disk is actually becoming more full
than the other (because the disk is smaller)

If I set my db file to 'unrestricted growth' I understand that it will grow
until the disk is full. If however the small disk does fill up (ie file 1),
will it automatically start using more space on the larger disk (ie the other
file in the group?) or will the database throw an error because one file is
full.

Any greatly appreciated

Yes, once the smaller disk fills up, the file on the second disk will start
to expand.

Though, instead of just sitting back and letting the drive fill up, you may
want to see a max on the size of the file on the smaller disk.



"Ron" <Ron@discussions.microsoft.com> wrote in message
news:27A727A6-10E4-4775-B7EB-19AE2B70CD56@microsoft.com...
> Hi All
>
> I have a db with multiple files in a filegroup, one file on a disk of
> it's
> own. (one disk is larger than the other). Currently sqlserver is
> distributing
> data on each disk equally so that one disk is actually becoming more full
> than the other (because the disk is smaller)
>
> If I set my db file to 'unrestricted growth' I understand that it will
> grow
> until the disk is full. If however the small disk does fill up (ie file
> 1),
> will it automatically start using more space on the larger disk (ie the
> other
> file in the group?) or will the database throw an error because one file
> is
> full.
>
> Any greatly appreciated
>