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
-
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