各位大虾,我以前用的是SQL2000,用下面的命令收缩数据库,现在换成2008,不好用了,请大虾们帮帮,先谢谢!
DBCC SHRINKFILE (zhibu_Data, 100) backup log zhibu with NO_LOG backup log zhibu with TRUNCATE_ONLY DBCC SHRINKDATABASE(zhibu)
DBCC SHRINKFILE (zhibu_Data, 100) backup log zhibu with NO_LOG backup log zhibu with TRUNCATE_ONLY DBCC SHRINKDATABASE(zhibu)
DBCC SHRINKDATABASE