The following Microsoft SQL Server T-SQL sample script illustrates FILEGROUP creation with multiple diskdrives:

-- SQL Server add filegroup to database - alter table

USE MASTER

GO

ALTER DATABASE SalesDW

ADD FILEGROUP [SalesHistory]

GO

ALTER DATABASE SalesDW

ADD FILE

(NAME = N'SalesDWArchive',

FILENAME = N'H:\SQL2005\SalesDW\SalesDWArchive.ndf',

SIZE = 40MB,

MAXSIZE = 5000MB,

FILEGROWTH = 10MB)

TO FILEGROUP [SalesHistory]

GO

ALTER DATABASE SalesDW

ADD FILE

(NAME = N'SalesDWArchive',

FILENAME = N'G:\SQL2005\SalesDW\SalesDWArchive.ndf',

SIZE = 2000MB,

MAXSIZE = 30000MB,

FILEGROWTH = 100MB)

TO FILEGROUP [SalesHistory]

GO