SQL SERVER 清除日志

/*

1.在SQL2008中清除日志就必须在简单模式下进行，等清除动作完毕再调回到完全模式。

2.这里的DBName_Log  可以通过以下查询
USE DBName
GO
SELECT file_id, name FROM sys.database_files

*/

USE [master]
GO
ALTER DATABASE DBName SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE DBName SET RECOVERY SIMPLE --简单模式
GO

USE DBName
GO
DBCC SHRINKFILE (N'DBName_Log' , 11, TRUNCATEONLY) 
GO

GO
USE [master]
GO
ALTER DATABASE DBName SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE DBName SET RECOVERY FULL --完全模式
GO