create database GSM1
on 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
)
sql 建立文件组示例
最新推荐文章于 2024-03-08 09:50:39 发布