复制代码 代码如下: –==================================================================== — SQL：数据库压缩语句 ———————————————————————- — Description: 压缩数据库 — Modif
复制代码 代码如下: –==================================================================== — SQL：数据库压缩语句 ———————————————————————- — Description: 压缩数据库 — Modify: x.zhong –==================================================================== DECLARE @db_name varchar(200) –得到当前数据库名称 declare getdbname cursor for select db_name() open getdbname fetch getdbname into @db_name while @@fetch_status = 0 begin fetch getdbname into @db_name end close getdbname DEALLOCATE getdbname –压缩数据库日志 DUMP TRANSACTION @db_name WITH NO_LOG BACKUP LOG @db_name WITH NO_LOG DBCC SHRINKDATABASE(@db_name)
