Create database sample

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

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7667023/viewspace-1009263/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7667023/viewspace-1009263/