filegroup

What is the advantage of having two secondary files inside a filegroup.
For example, I can create a table and place it inside a filegroup which obviously will use the secondary files.
Not sure why some DBAs create just one but otherscreate more than one secondar files in a filegroup.
I have read the booksonline but can not figure out the advantages.
Thanks

suppose you have a file in filegroup on a hard disk and the hard disk will be full by your file now you can add another hard disk and add a file in filegroup and place it on new Hard disk

File Group and Databases

I currently have a database that is 16gig data. I would like to create a
secondary file in the same filegroup and split that 16gig across the two
files. This would allow for growth and some performance perhaps.
I can not figure out how to migrate the data from the first file group to
the second or split it across the two.
Any suggestions would be helpful. I am running sql2k sp4.Thom,
To my knowledge objects can only move across filegroups directly. So if you
want to place an table on another file in another filegroup, create a
user-defined filegroup, add the file to the filegroup and then create a
clustered index for the table using the ON FILEGROUP clause. If the index
already exists, use the WITH DROP_EXISTING clause as well.
HTH
Jerry
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:46737483-EA39-4007-BCF9-9DA970C45E9B@.microsoft.com...
>I currently have a database that is 16gig data. I would like to create a
> secondary file in the same filegroup and split that 16gig across the two
> files. This would allow for growth and some performance perhaps.
> I can not figure out how to migrate the data from the first file group to
> the second or split it across the two.
> Any suggestions would be helpful. I am running sql2k sp4.