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