sql 建立文件组示例

create database GSM1on primary           --主文件及主文件组(  name = main1,       --逻辑文件名  filename = 'c:\program files\microsoft sql server\mssql.2\mssql\data\mian1.mdf', --物理文件名  size = 10MB,        --初始大小  filegrowth = 1MB    --增长速度),  (  name = main2,     filename = 'c:\program files\microsoft sql server\mssql.2\mssql\data\mian2.ndf',  size = 10MB, filegrowth = 1MB),filegroup group1      --文件组group1(  name = data, filename = 'F:\数据库\GSM\data.ndf', size = 5MB, filegrowth = 1MB),filegroup group2      --文件组group2(  name = indexInfo, filename = 'D:\SQL2005\index\GSM\indexInfo.ndf', size = 5MB, filegrowth = 1MB)log on                --日志文件(  name = 'GSM.log',   filename = 'c:\program files\microsoft sql server\mssql.2\mssql\data\GSMlog.ldf' ,   size = 2048KB , filegrowth = 1MB)