我同事写的一段压缩MS SQL Server日志的语句

--====================================================================-- SQL：数据库压缩语句------------------------------------------------------------------------ Description: 压缩数据库-- Modify: x.zhong--====================================================================DECLARE @db_name varchar(200)--set @db_name='tm_dsz_sys' --数据库名--得到当前数据库名称declare getdbname cursor for select db_name()open getdbnamefetch getdbname into @db_namewhile @@fetch_status = 0begin fetch getdbname into @db_nameend close getdbnameDEALLOCATE getdbname--压缩数据库日志DUMP TRANSACTION @db_name WITH NO_LOGBACKUP LOG @db_name WITH NO_LOGDBCC SHRINKDATABASE(@db_name)