Avatar of slam69
slam69
Flag for United Kingdom of Great Britain and Northern Ireland asked on

SQL replication DR for distribution agent

Hi All,

New Company using trans and merge replication. Looking to rebuild to just use merge, but having difficulties coming up with suitable redundancy for a DR on the distribution agent.

The Distribuition agent will be a remote setup on a standalone box, whilst I am aware I can cluster this to give redundancy Im exploring other avenues and wish to know if it is possible to use a server alias on all clients and point to a mirrored distribution agent?

Any advice is welcome

Thx all
Microsoft SQL Server 2008Microsoft SQL Server 2005Microsoft SQL Server

Avatar of undefined
Last Comment
EugeneZ

8/22/2022 - Mon
EugeneZ

replication does not like server alias..

<wish to know if it is possible to use a server alias on all clients and point to a mirrored distribution agent?>

--this part needs clarification ..specialy you have clustered solution that will keep your distr sql server name:
you are on 1 node or failover to another node for outside ("all clients") it is the same sql server (sql clustering is an another topic)



slam69

ASKER
Hi Apologies for delay. Sry if I wasnt clear, I am fine for the clustered solution, however i am not sure if we will get teh go-ahead to deploy another sql cluster. If we are unable to I am looking at alternatives to a cluster to provide redundancy so need to know if an alias for the distributor would work.

Just for clarification and to re-iterate, will a server alias for a distributor work in an unclustered topology.

Thx again,

Jay
EugeneZ

to set replication you would need to use sql server name(@@servername )
as sql server - you can connect it as an alias
BTW: what an alias we are talking about in this case?
sql or DNS?
Your help has saved me hundreds of hours of internet surfing.
fblack61
slam69

ASKER
sql alias as in cliconfg.exe
ASKER CERTIFIED SOLUTION
EugeneZ

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
slam69

ASKER
Cool thats what i needed to know back to the drawing board then and on with getting budget for a cluster :)

Thx again

Jay
EugeneZ

try virtual cluster server..
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.