创建数据库

时间：2011-05-21 来源：stswordman

create database testdb
go
alter database testdb
add filegroup DFG
go
alter database testdb
add file
(
    name=testdb1,
    filename='d:\sqldata\testdb1.ndf',
    size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=testdb2,
    filename='d:\sqldata\testdb2.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=testdb3,
    filename='d:\sqldata\testdb3.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=testdb4,
    filename='d:\sqldata\testdb4.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=testdb5,
    filename='d:\sqldata\testdb5.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=testdb6,
    filename='d:\sqldata\testdb6.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=testdb7,
    filename='d:\sqldata\testdb7.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=testdb8,
    filename='d:\sqldata\testdb8.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
)

相关阅读更多 +