Posted by Gert E.R. Drapers on 05/27/05 11:10

You can not turn this behavior off. I think what you mean is that when you
add a file to the filegroup the data is not re-balanced to evenly distribute
the data across all files including the new one. This is the way the system
is designed. You would have to force it by rebuilding indexes, but this
introduces a space requirement and a period in which the table is offline
during the rebuild.

GertD@SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright � SQLDev.Net 1991-2005 All rights reserved.

"Danny" <someone@nowhere.com> wrote in message
news:9dRke.1781$5T2.877@trnddc01...
> All,
>
> SQL Server uses a proportional fill method to add data to file groups
> where a file group has multiple files. In general this is a good thing.
> Unfortunately, the method appears to get switched off when new file(s) is
> added. Other than exporting the data out of the filegroup, recreating the
> filegroup and putting the data back in, is there a way to respread the
> existing data back out and switching the proportional fill method back on?
>
> Thanks,
> Danny
>

[Back to original message]