#2
ZHRXJR2017-09-27 11:27
|
请问为什么(filegroup usergroup会报错,我应该怎么修改呢)
create database product
on primary(
name='p1_data',
filename='d:\sqllx\product_data1.mdf',
size=5MB,
filegrowth=15%
)
filegroup usergroup
(name ='p2_data',
filename ='d:\ sqllx \ product_data2.ndf ' ,
SIZE = 3MB, MAXSIZE=10MB,
filegrowth = 15%)
log on(
name='p1_log',
filename='d:\sqllx\product_log1.ldf',
size=2MB,
filegrowth=10%
),
(
name='p2_log',
filename='d:\sqllx\product_log2.ldf',
size=2MB,
filegrowth=10%
)
go