清理sql server log 文件

declare @db nvarchar(20)

set @db='KLims'

 

dump transaction @db with no_log

backup log @db with no_log

 

dbcc shrinkdatabase(@db)