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