8-42.sql

sql2000工程实践一书第8张源代码

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