1.先查询数据库日志文件并?住后面用到(中括号必有不然报错).

USE [数据库名]   

GO  

select name from SYS.database_files where type_desc='LOG'

2.先进入单用户模式进行删除后再进入安全模式

USE [master]  

GO  

ALTER DATABASE [数据库名] SET RECOVERY SIMPLE WITH NO_WAIT  

GO  

ALTER DATABASE [数据库名] SET RECOVERY SIMPLE  

GO  

USE [数据库名]  

GO  

DBCC SHRINKFILE (N'[数据库日志文件名称]' , 0,truncateONLY)  

GO  

USE [master]  

GO  

ALTER DATABASE [数据库名] SET RECOVERY FULL WITH NO_WAIT  

GO  

ALTER DATABASE [数据库名] SET RECOVERY FULL  

GO