-
The primary filegroup with the files Spri1_dat and Spri2_dat. The FILEGROWTH increment for both of these files is specified as 15 percent.
-
A filegroup named SalesGroup1 with the files SGrp1Fi1 and SGrp1Fi2.
-
A filegroup named SalesGroup2 with the files SGrp2Fi1 and SGrp2Fi2.
CREATE DATABASE Sales
ON PRIMARY
( NAME = SPri1_dat,
FILENAME =
'c:program filesmicrosoft sql servermssql.1mssqldataSPri1dat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 15% ),
( NAME = SPri2_dat,
FILENAME =
'c:program filesmicrosoft sql servermssql.1mssqldataSPri2dat.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 15% ),
FILEGROUP SalesGroup1
( NAME = SGrp1Fi1_dat,
FILENAME =
'c:program filesmicrosoft sql servermssql.1mssqldataSG1Fi1dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
( NAME = SGrp1Fi2_dat,
FILENAME =
'c:program filesmicrosoft sql servermssql.1mssqldataSG1Fi2dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
FILEGROUP SalesGroup2
( NAME = SGrp2Fi1_dat,
FILENAME =
'c:program filesmicrosoft sql servermssql.1mssqldataSG2Fi1dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
( NAME = SGrp2Fi2_dat,
FILENAME =
'c:program filesmicrosoft sql servermssql.1mssqldataSG2Fi2dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME =
'c:program filesmicrosoft sql servermssql.1mssqldatasaleslog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB );
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7667023/viewspace-1009263/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7667023/viewspace-1009263/