/*扩充数据库*/
alert database Mydatabase
modify file
(
name='Mydatabase_data',
size=10M
)
go
alert database Mydatabase
modify file
(
name='Mydatabase_Log',
size=10M
)
go
/*压缩数据库*/
use Mydatabase
DBCC shrinkfile(Mydatabase_Data,5);/*将数据库的数据文件压缩到5M*/
DBCC shrinkfile(Mydatabase_Log,5);/*将数据库的日志文件压缩到5M*/