创建数据库

 

create database scm
on
(
      name=scm,
    filename='d:\sqldata\scm.mdf'
    ,size=3mb,
    FILEGROWTH = 1mb
)
log on
(
    name=scm_log,
    filename='f:\sqldata\scm_log.ldf'
    ,size=10000mb,
    FILEGROWTH = 100mb
)
go
alter database scm
add filegroup DFG
go
alter database scm
add file
(
    name=scm1,
    filename='d:\sqldata\scm1.ndf',
    size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=scm2,
    filename='d:\sqldata\scm2.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=scm3,
    filename='d:\sqldata\scm3.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=scm4,
    filename='d:\sqldata\scm4.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=scm5,
    filename='d:\sqldata\scm5.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=scm6,
    filename='d:\sqldata\scm6.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=scm7,
    filename='d:\sqldata\scm7.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
),
(
    name=scm8,
    filename='d:\sqldata\scm8.ndf'
    ,size=10000mb,
    FILEGROWTH = 100mb
)
to filegroup DFG
go
alter database scm
modify filegroup dfg default