how to create filegroups

I was directed to create filegroups so that clients that install msde or sql
server would look the same Can anyone point me in the right direction on how
to
create the filegroups on msde.
I was thinking about just splitting up the indexes and tables at this
point. Is this what a sql server install would do so that they could take
advantage of Raid drive?
See Filegroups|Creating in Books Online. The basic syntax is:
ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
Then add files to the filegroup with:
ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
<filegroupname>
Jacco Schalkwijk
SQL Server MVP
"Keeper" <Keeper@.discussions.microsoft.com> wrote in message
news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>I was directed to create filegroups so that clients that install msde or
>sql
> server would look the same Can anyone point me in the right direction on
> how
> to
> create the filegroups on msde.
> I was thinking about just splitting up the indexes and tables at this
> point. Is this what a sql server install would do so that they could take
> advantage of Raid drive?
>
|||i appreciate the information
thanx
"Jacco Schalkwijk" wrote:

> See Filegroups|Creating in Books Online. The basic syntax is:
> ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
> Then add files to the filegroup with:
> ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
> <filegroupname>
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Keeper" <Keeper@.discussions.microsoft.com> wrote in message
> news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>
>