创建数据库

 

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

 

posted on 2011-05-21 22:09  stswordman  阅读(293)  评论(0编辑  收藏  举报