示例2.sql

SQL Server数据库设计和高级查询[SQL Advance]

CREATE  DATABASE  employees
  ON 
   (
   /*-主数据文件的具体描述-*/
   NAME = 'employee1', 
   FILENAME = 'D:\project\employee1_Data.mdf' , 
   SIZE = 10, 
   FILEGROWTH = 10%
  ), 
  (
   /*-次要数据文件的具体描述-*/
   NAME = 'employee2', 
   FILENAME = 'D:\project\employee2_Data.ndf' , 
   SIZE = 20, 
   MAXSIZE = 100, 
   FILEGROWTH = 1
  ) 
 LOG ON 
  (
   /*-日志文件1的具体描述-*/
   NAME = 'employeelog1', 
   FILENAME = 'D:\project\employeelog1_Log.ldf' , 
   SIZE = 10, 
   FILEGROWTH = 1
   ), 
  (
   /*-日志文件2的具体描述-*/
   NAME = 'employeelog2', 
   FILENAME = 'D:\project\employeelog2_Log.ldf' , 
   SIZE = 10, 
   MAXSIZE = 50, 
   FILEGROWTH = 1
  )
GO