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.

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.

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.