创建SQL 有误?错在哪呢?

USE master
GO
CREATE DATABASE testbase2
ON
PRIMARY
(NAME = prim_sub_dat1,
FILENAME = 'G:\SQL SERVER2000\prim_sub_dat.mdf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROWTH = 20%),
(NAME = prim_sub_dat2,
FILENAME = 'G:\SQL SERVER2000\prim_sub_dat.ndf'
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROWTH = 20% ),
FILEGROUP Grouptest1
(NAME = group1_sub1,
FILENAME= 'G:\SQL SERVER2000\group1_sub1_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROUP = 5MB ),
(NAME = group1_sub2,
FILENAME = 'G:\SQL SERVER2000\group1_sub2_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,)
FILEGROUP Grouptest2
(NAME = group2_sub1,
FILENAME = 'G:\SQL SERVER2000\group2_sub1_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROUP = 15%),
(NAME = group2_sub2,
FILENAME = 'G:\SQL SERVER2000\group2_sub2_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROUP =15% )
LOG ON
( NAME = testbase2_log,
FILENMAE ='G:SQL SERVER2000\testbase2_log_file.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROUP = 5MB )
GO
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值