1.先查詢(xún)數(shù)據(jù)庫(kù)日志文件并?住后面用到(中括號(hào)必有不然報(bào)錯(cuò)).

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

GO  

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

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

USE [master]  

GO  

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

GO  

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

GO  

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

GO  

DBCC SHRINKFILE (N'[數(shù)據(jù)庫(kù)日志文件名稱(chēng)]' , 0,truncateONLY)  

GO  

USE [master]  

GO  

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

GO  

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

GO