清空sql 日志

USE [master]
GO
ALTER DATABASE 库名 SET RECOVERY SIMPLE
GO
USE 库名
GO
DBCC SHRINKFILE(2,0,TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE 库名 SET RECOVERY FULL
GO