Link to home
Start Free TrialLog in
Avatar of slam69
slam69Flag 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
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

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)



Avatar of 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
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?
Avatar of slam69

ASKER

sql alias as in cliconfg.exe
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 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
try virtual cluster server..