第5讲++创建管理数据库

实例

 

create database  db
on
(
    name=db51,
    filename='D:\xxx\db51.mdf',
    size=100,
    maxsize=200,
    filegrowth=20
),
(
    name=db52,
    filename='D:\xxx\db52.ndf',
    size=100,
    maxsize=200,
    filegrowth=20
),
(
    name=db53,
    filename='D:\xxx\db53.ndf',
    size=100,
    maxsize=200,
    filegrowth=20
)
log on
(
    name=db5log1,
    filename='D:\xxx\db5log1.ldf'
),
(
    name=db5log2,
    filename='D:\xxx\db5log2.ldf',
    size=50,maxsize=200,filegrowth=20
)