Export-DbaReplServerSetting fails when using remote distributor #9487
Unanswered
klindberg70
asked this question in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I have a replication setup with remote distributors. I want to export the replication settings and it works fine if distributor is in the same instance as the publisher but it fails when using a remote distributor
PS > get-dbareplserver sql1
ComputerName : SQL1
InstanceName : MSSQLSERVER
SqlInstance : SQL1
IsDistributor : False
IsPublisher : True
DistributionServer : SQL2
DistributionDatabase : distribution
PS > get-dbareplserver sql1 | Export-DbaReplServerSetting -Path C:\temp\replication.sql
WARNING: [08:28:55][Export-DbaReplServerSetting] Replication export failed. Is it setup? | The specified @job_id ('5451243D-702F-414D-93C3-3A7DD2A8BC65') does not exist.
PS > Export-DbaReplServerSetting -SqlInstance sql1
WARNING: [09:02:23][Export-DbaReplServerSetting] Replication export failed. Is it setup? | The specified @job_id ('5451243D-702F-414D-93C3-3A7DD2A8BC65') does not exist.
The job does exist on SQL2
Beta Was this translation helpful? Give feedback.
All reactions