修改資料庫

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