清空SQL数据库日志

--SQL2005
Backup Log dbName with no_log
go
dump transaction dbName with no_log 
go
USE dbName
DBCC SHRINKFILE (2)
Go


--SQL2008
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
USE [master]
GO
ALTER DATABASE dbName SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE dbName SET RECOVERY FULL
GO