清空数据Log记录

   清空数据Log记录

   EXEC [master].dbo.sp_MSforeachdb  
         @command1="set nocount on dump  transaction [?]
   with no_log backup log [?] with no_log 
  dbcc shrinkdatabase([?]) set nocount off"

方法二：

    backup log [table] with no_log
    dbcc shrinkdatabase([table])