use master
Go
Create Database sales
ON Primary
(
Name=ting1,
FileName='I:\数据库\数据库练习\sales\ting1.mdf',
Size=8MB,
Maxsize=10MB,
Filegrowth=0
)
(
name=ting12,
Filename='I:\数据库\数据库练习\sales\ting12.ndf',
Size=6MB,
Maxsize=10MB,
Filegrowth=2%
)
Filegroup SalesGroup1
(
Name=SGrp_file1,
Filename='I:\数据库\数据库练习\sales\SGrp_file1.ndf',
Size=5,
Filegrowth=2
)
(Name=SGrp_file2,
FileName='I:\数据库\数据库练习\sales\SGrp_file2.ndf',
Size=6,
Filegrowth=5
)
LOg on
(
Name=sale_log1,
Filename='I:\数据库\数据库练习\sales\sale_log1.ldf',
Size=6,
Maxsize=20,
Filegrowth=10
)
(Name=sale_log2,
Filename='I:\数据库\数据库练习\sales\sale_log2.ldf',
Size=7,
Maxsize=20,
Filegrowth=10
)
Go
use sales
Go

解决方案 »

  1.   

    use master
    Go
    Create Database sales
    ON Primary
    (
    Name=ting1,
    FileName='I:\数据库\数据库练习\sales\ting1.mdf',
    Size=8MB,
    Maxsize=10MB,
    Filegrowth=0
    ),
    (
    name=ting12,
    Filename='I:\数据库\数据库练习\sales\ting12.ndf',
    Size=6MB,
    Maxsize=10MB,
    Filegrowth=2%
    ),
    Filegroup SalesGroup1
    (
    Name=SGrp_file1,
    Filename='I:\数据库\数据库练习\sales\SGrp_file1.ndf',
    Size=5,
    Filegrowth=2
    ),
    (Name=SGrp_file2,
    FileName='I:\数据库\数据库练习\sales\SGrp_file2.ndf',
    Size=6,
    Filegrowth=5
    )
    LOg on
    (
    Name=sale_log1,
    Filename='I:\数据库\数据库练习\sales\sale_log1.ldf',
    Size=6,
    Maxsize=20,
    Filegrowth=10
    ),
    (Name=sale_log2,
    Filename='I:\数据库\数据库练习\sales\sale_log2.ldf',
    Size=7,
    Maxsize=20,
    Filegrowth=10
    )
    Go
      

  2.   

    參照CREATE DATABASE  Sales
    ON PRIMARY
    ( NAME = SPri1_dat,
        FILENAME = 'C:\SPri1dat.mdf',
        SIZE = 10,
        MAXSIZE = 50,
        FILEGROWTH = 15% ),
    ( NAME = SPri2_dat,
        FILENAME = 'C:\SPri2dt.ndf',
        SIZE = 10,
        MAXSIZE = 50,
        FILEGROWTH = 15% ),
    FILEGROUP SalesGroup1
    ( NAME = SGrp1Fi1_dat,
        FILENAME = 'C:\SG1Fi1dt.ndf',
        SIZE = 10,
        MAXSIZE = 50,
        FILEGROWTH = 5 ),
    ( NAME = SGrp1Fi2_dat,
        FILENAME = 'C:\SG1Fi2dt.ndf',
        SIZE = 10,
        MAXSIZE = 50,
        FILEGROWTH = 5 ),
    FILEGROUP SalesGroup2
    ( NAME = SGrp2Fi1_dat,
        FILENAME = 'C:\SG2Fi1dt.ndf',
        SIZE = 10,
        MAXSIZE = 50,
        FILEGROWTH = 5 ),
    ( NAME = SGrp2Fi2_dat,
        FILENAME = 'C:\SG2Fi2dt.ndf',
        SIZE = 10,
        MAXSIZE = 50,
        FILEGROWTH = 5 )
    LOG ON
    ( NAME = Sales_log,
        FILENAME = 'C:\salelog.ldf',
        SIZE = 5MB,
        MAXSIZE = 25MB,
        FILEGROWTH = 5MB )
      

  3.   

    改為use master
    Go
    Create Database sales
    ON Primary
    (
    Name=ting1,
    FileName='I:\数据库\数据库练习\sales\ting1.mdf',
    Size=8MB,
    Maxsize=10MB,
    Filegrowth=0
    ),
    (
    name=ting12,
    Filename='I:\数据库\数据库练习\sales\ting12.ndf',
    Size=6MB,
    Maxsize=10MB,
    Filegrowth=2%
    ),
    Filegroup SalesGroup1
    (
    Name=SGrp_file1,
    Filename='I:\数据库\数据库练习\sales\SGrp_file1.ndf',
    Size=5,
    Filegrowth=2
    ),
    (Name=SGrp_file2,
    FileName='I:\数据库\数据库练习\sales\SGrp_file2.ndf',
    Size=6,
    Filegrowth=5
    )
    LOg on
    (
    Name=sale_log1,
    Filename='I:\数据库\数据库练习\sales\sale_log1.ldf',
    Size=6,
    Maxsize=20,
    Filegrowth=10
    ),
    (Name=sale_log2,
    Filename='I:\数据库\数据库练习\sales\sale_log2.ldf',
    Size=7,
    Maxsize=20,
    Filegrowth=10
    )
    Go