有一个 database的transaction每天长大10G左右,
Shrink file 没办法缩到很小
https://imgur.com/Kts76wZ.jpg
看sys.database,状态是REPLICATION,左边的replication是有在运作的
https://imgur.com/YXuQ8Wf.jpg
这篇说 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
请问还是有其它方法?
谢谢