sql2008及以后版本，日志压缩方法

SELECT NAME, recovery_model_desc FROM sys.databases where name='ufdata_666_2010'

--如果是FULL类型，修改为SIMPLE类型　

-->>ALTER DATABASE [dbname] SET Recovery simple

--ALTER DATABASE ufdata_666_2010 SET Recovery simple

select * from ufdata_666_2009.

-->>执行数据库逻辑文件收缩

use ufdata_666_2010

go

DBCC SHRINKFILE (Ufmodel_LOG)

go

DBCC SHRINKFILE (Ufmodel)

go

--收缩前log：22.8 GB (24,498,405,376 字节)

--执行数据库收缩

DBCC SHRINKDATABASE(ufdata_666_2010)

--收缩前：39.7 GB (42,707,058,688 字节)

日志类型先设置为simple ALTER DATABASE ufdata_666_2010 SET Recovery simple

处理完后

日志类型先设置为full ALTER DATABASE ufdata_666_2010 SET Recovery full