LDF 檔瘦身
三月 19, 2010
declare @db nvarchar(20)
set @db=’資料庫名稱’
dump transaction @db with no_log
backup log @db with no_log
dbcc shrinkdatabase(@db)
declare @db nvarchar(20)
set @db=’資料庫名稱’
dump transaction @db with no_log
backup log @db with no_log
dbcc shrinkdatabase(@db)