7-03.sql

来自「包括本书所有的源代码。所有程序均在Windows 2000+IIS5.0+SQL」· SQL 代码 · 共 30 行

CREATE DATABASE Archive 
ON
PRIMARY ( NAME = Arch1,
      FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat1. mdf',
      SIZE = 1MB,
      MAXSIZE =1,
      FILEGROWTH = 1),
( NAME = Arch2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat2.ndf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH = 1),
( NAME = Arch3,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat3.ndf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH = 1)
LOG ON 
( NAME = Archlog1,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog1.ldf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH =1),
( NAME = Archlog2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog2.ldf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH =1)
GO