مطالب مرتبط با «remote distribution database» در Stack Exchange | نویسنده: رضا رضوی
remote distribution database - Agent message code 21482. sp_MShelp_repl_agent can only be executed in the "distribution" database
I have a situation for which I would appreciate any valuable pointers. I have sql transactional replication configured as below. sql01sqla ---> publisher sql01sqlc --> subscriber sql01sqle ---> distributor. I am testing if I can recover my replication flow , in the event of losing the distribution host, I have put distribution database in full recovery model and am taking log backups every 15mins. After configuring transactional replication, and ensuring a table is in sync, i stopped the agents (log reader and distribution ) on the distribution host. inserted a few records on publication and ensure the log back job of the publisher db is disabled as well. Now restored distribution database f...
ادامه مطلب
