createdb.sql

该章文件夹Chap2下存放的都是SQL脚本文件

CREATE DATABASE myDB1
ON
PRIMARY ( NAME = DB1,
      FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\data\dat1.mdf',
      SIZE = 10MB,
      MAXSIZE = 50,
      FILEGROWTH = 10),
( NAME = DB2,
   FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\data\dat2.ndf',
   SIZE = 10MB,
   MAXSIZE = 50,
   FILEGROWTH = 10)
LOG ON 
( NAME = log1,
   FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\data\log1.ldf',
   SIZE = 10MB,
   MAXSIZE = 20,
   FILEGROWTH = 5)
GO