8-41.sql

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

USE master
GO
ALTER DATABASE college
ADD FILEGROUP collegeFG
GO

ALTER DATABASE college
ADD FILE 
( NAME = college_Data2,
  FILENAME = 'C:\college\college_Data2.ndf',
  SIZE = 5MB,
  MAXSIZE = 100MB,
  FILEGROWTH = 5MB),
( NAME = college_Data3,
  FILENAME = 'C:\college\college_Data3.ndf',
  SIZE = 5MB,
  MAXSIZE = 100MB,
  FILEGROWTH = 5MB)
TO FILEGROUP collegeFG

ALTER DATABASE college
MODIFY FILEGROUP collegeFG DEFAULT
GO