修改数据库

alter database binbin    -------(向次要数据库文件组中添加文件)
add file
(
name='jay_3',
filename='d:/jay_3.ndf',
size=5MB,
maxsize=10MB,
filegrowth=10
)
to filegroup jay
------------------
alter database binbin   --------(添加日志文件)
add log file
(
name='binbin_3',
filename='d:/binbi_3.ldf',
size=5MB,
maxsize=10MB,
filegrowth=10
)
------------------
alter database binbin    --------(添加文件组)
add filegroup bingbing

---------------------
alter database binbin
remove file jay_2    ---------(删除文件)

-----------------------
alter database binbin     ---------(删除文件组)
remove filegroup bingbing
--------------------------------
alter database binbin
modify file         --------------(修改文件的大小)
(
name='jay_1',       -------（size,maxsize 都要比原来的大）      
size=10MB,
maxsize=30MB,       --------(不用写 filename )
filegrowth=10MB
)
-----------删除数据库-----------------------------
--drop database binbin