SQL SERVER 创建数据库

在D盘创建一个以张三名字命名数据库，要求数据文件初始值5MB,最大值不受限制，增量为10%；事务日志文件初始值2MB,最大值10MB，增量为1 MB。

create database 张三
on
primary 
(
    name=Test3,
    filename='D:\db\Test.mdf',
    size=5MB,
    maxsize=10MB,
    filegrowth=50%
)
log on
(
    name=Test3_log,
    filename='D:\db\Test_log.ldf',
    size=2MB,
    maxsize=10MB,
    filegrowth=50%
)

create database zhangsan on ( name=zhangsan_data, filename='d:\sqlserver\data\zhangsan.mdf', size=5MB, filegrowth=10%, maxsize=unlimited ) log on ( name=zhangsan_log, filename='d:\sqlserver\data\zhangsan.ldf', size=2MB, maxsize=10MB, filegrowth=1MB )