SQLServer 收缩日志文件

-- SQL Server 2000 收缩日志文件USE UnitedFrontDepart_Infomation  
GO

DUMP     TRAN       UnitedFrontDepart_Infomation  with no_log 
BACKUP     LOG       UnitedFrontDepart_Infomation  with no_log 
DBCC shrinkdatabase (UnitedFrontDepart_Infomation)


-- SQL Server 2000 重命名数据库名称
USE master  
GO

EXEC sp_dboption 'UnitedFrontDepart_DailyWork', 'Single User', 'TRUE' 
EXEC sp_renamedb 'UnitedFrontDepart_DailyWork', 'YHGO_DailyWork' 
EXEC sp_dboption 'YHGO_DailyWork', 'Single User', 'FALSE'



-- SQL Server 2008 收缩日志文件
-- SQL2008中清除日志就必须在简单模式下进行，等清除动作完毕再调回到完全模式
USE [master]
GO

ALTER DATABASE DNName SET RECOVERY SIMPLE WITH NO_WAIT
GO

ALTER DATABASE DNName SET RECOVERY SIMPLE --简单模式
GO

USE DNName
GO

DBCC SHRINKFILE (N'DNName_Log' , 11, TRUNCATEONLY)
GO

USE [master]
GO

ALTER DATABASE DNName SET RECOVERY FULL WITH NO_WAIT

GO

ALTER DATABASE DNName SET RECOVERY FULL --还原为完全模式
GO

--优点：此清除日志所运行消耗的时间短