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
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
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
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 )
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