Viewing 11 posts - 31 through 41 (of 41 total)
Hi,
As far I know distribution agent ONLY accessing distributor and distribution db. Only logreader and snapshot agents are accessing publisher. Unless you setup local distribution then distribution agent...
BartL
Replication Blog
April 14, 2017 at 6:21 am
I have a transaction replication and the subscription was synced from snapshot years ago....
BartL
Replication Blog
January 24, 2017 at 8:13 am
I got this error in two cases.
1. Db ownership (as other people said sp_changedbowner 'sa' - do not use GUI to do this).
2. Permission issues
Please check first what user...
BartL
Replication Blog
December 23, 2016 at 4:12 am
Correct me if Im wrong there are more than one subscriptions going into same database? One is pull and second push?
The only big difference between these two is the location...
BartL
Replication Blog
December 22, 2016 at 7:46 am
doesnt seem like it is issue with Distribution Agent profile as it got the values for the given profile:
2016-12-05 00:41:46.179 Parameter values obtained from agent profile:
-bcpbatchsize 2147473647
-commitbatchsize 100
-commitbatchthreshold 1000
-historyverboselevel 2
-keepalivemessageinterval...
BartL
Replication Blog
December 16, 2016 at 7:28 am
HI,
Yes we did upgrade subscribers before and we did not stop activity on publisher. Either u can stop logreader or distribution agent before doing an upgrade on subscriber.
BartL
Replication Blog
November 24, 2016 at 3:44 am
Could u check logreader and Snapshot? Any of these is failing or giving some error?
BartL
Replication Blog
November 9, 2016 at 3:16 am
dwilliscp (10/29/2016)
BartL
Replication Blog
November 8, 2016 at 1:40 pm
Im assuming u want to use transactional replication and have date in real time on subscribers?
If yes, then it is one of the best solutions to offload data for reading...
BartL
Replication Blog
November 8, 2016 at 6:57 am
SQL-DBA-01 (11/4/2016)
1 transaction(s) with 1 command(s) were delivered.
How to validate what was the change been applied to...
BartL
Replication Blog
November 8, 2016 at 6:00 am
Seems like problem with updating distributor. Is it accessible?
Try add parameter
@ignore_distributor = 1
BartL
Replication Blog
November 8, 2016 at 5:40 am
Viewing 11 posts - 31 through 41 (of 41 total)