8-41.sql

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

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