8-42.sql

来自「sql2000工程实践一书第8张源代码」· SQL 代码 · 共 16 行

USE master
GO
ALTER DATABASE college
ADD LOG FILE 
( NAME = college_Log2,
  FILENAME = 'C:\college\college_Log2.ldf',
  SIZE = 5MB,
  MAXSIZE = 100MB,
  FILEGROWTH = 5MB),
( NAME = college_Log3,
  FILENAME = 'C:\college\college_Log3.ldf',
  SIZE = 5MB,
  MAXSIZE = 100MB,
  FILEGROWTH = 5MB)
GO