在SQL Sever 上创建数据库的命令

create database test
on
primary(name=test,
filename='E:\test.mdf',
size=4mb,
maxsize=10mb,
filegrowth=2mb
)
log on
(name=testlog,
filename='E:\testlog.ldf',
size=1mb,
maxsize=5mb,
filegrowth=1mb
)