SQL server2000中用命令和图形界面两种方式创建库
create database zz on(
name='zz00_data',
filename='c:\sql2000\zz00.mdf',
size=10mb,
maxsize=20mb,
filegrowth=2mb
),
filegroup z1
(
name='zz11_data',
filename='c:\sql2000\zz11.ndf',
size=10mb,
maxsize=20mb,
filegrowth=2mb
),
(
name='zz12_data',
filename='c:\sql2000\zz12.ndf',
size=2mb,
maxsize=20mb,
filegrowth=1mb
),
filegroup z2
(
name='zz21_data',
filename='c:\sql2000\zz21.ndf',
size=1mb,
maxsize=10mb,
filegrowth=2%
)
页:
[1]