[討論] MS SQL trxn log 無法縮小 (REPLICATION)

作者: chings22 (chings22)   2021-07-10 16:21:44
有一個 database的transaction每天長大10G左右,
Shrink file 沒辦法縮到很小

看sys.database,狀態是REPLICATION,左邊的replication是有在運作的

這篇說 sp_repldone,可行嗎?
https://reurl.cc/EnY1Zv
EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time =
0, @reset = 1
這篇說removereplication,但會不會replication全刪掉了?
https://www.twblogs.net/a/5db356fbbd9eee310da03f32
EXEC sp_removedbreplication xxx
還是有其它方法?

Links booklink

Contact Us: admin [ a t ] ucptt.com