1.先查詢數(shù)據(jù)庫日志文件并記住后面用到(中括號必有不然報錯).

USE [數(shù)據(jù)庫名]   

GO  

SELECT name FROM SYS.database_files WHERE type_desc='LOG'

2.先進(jìn)入單用戶模式進(jìn)行刪除后再進(jìn)入安全模式

USE [master]  

GO  

ALTER DATABASE [數(shù)據(jù)庫名] SET RECOVERY SIMPLE WITH NO_WAIT  

GO  

ALTER DATABASE [數(shù)據(jù)庫名] SET RECOVERY SIMPLE  

GO  

USE [數(shù)據(jù)庫名]  

GO 

DBCC SHRINKFILE (N'[數(shù)據(jù)庫日志文件名稱]' , 0,TRUNCATEONLY)  

GO  

USE [master]  

GO  

ALTER DATABASE [數(shù)據(jù)庫名] SET RECOVERY FULL WITH NO_WAIT  

GO  

ALTER DATABASE [數(shù)據(jù)庫名] SET RECOVERY FULL  

GO