|
ALTER DATABASE db_name
ADD FILE file_spec1 [TO FILEGROUP group_name1]
|ADD LOG FILE file_spec2
|REMOVE FILE 'file_name'
|MODIFY FILE (NAME = old_name, NEWNAME = new_name ...)
|CREATE FILEGROUP group_name2 | DROP FILEGROUP filegroup_name3
|SET option_specifications [WITH terminations]
13> create database projects;
14>
15> ALTER DATABASE projects
16> ADD FILE (NAME=projects_dat1,
17> FILENAME = 'C:\DATA\projects1.mdf',
18> SIZE = 10,
19> MAXSIZE = 100,
20> FILEGROWTH = 5)
21>
22> drop database projects;
23> GO
|