SQL Server 创建数据库

use master
go
CREATE DATABASE EMIS301
ON PRIMARY
 (
  NAME='emis301_1',
  FILENAME='D:\DATABASE301\emis301.mdf',
  SIZE=10Mb,
  MAXSIZE=unlimited,
  FILEGROWTH=50%
 ),
 (
  NAME='emis301_2',
  FILENAME='D:\DATABASE301\emis301_2.ndf',
  SIZE=10Mb,
  MAXSIZE=500MB,
  FILEGROWTH=10
 ),
 FILEGROUP business_group
 (
  NAME='emis301_3',
  FILENAME='D:\DATABASE301\emis301_3.ndf',
  SIZE=10Mb,
  MAXSIZE=50MB,
  FILEGROWTH=10%
 )
LOG ON
 (
  NAME='emis301_log',
  FILENAME='D:\DATABASE301\emis301_log.ldf',
  SIZE=5Mb,
  MAXSIZE=200Mb,
  FILEGROWTH=3Mb
 ),
 (
  NAME='emis301_2log',
  FILENAME='D:\DATABASE301\emis301_2log.ldf',
  SIZE=8Mb,
  MAXSIZE=100Mb,
  FILEGROWTH=10Mb
 )