Post reply

Replication between 2 sql 2k2014 that has the same IP

  • April 30, 2018 at 2:51 am

    #1988609

    Would a failover cluster (FCI) fulfil the brief for you?

  • April 30, 2018 at 4:09 am

    #1988612

    Beatrix Kiddo - Monday, April 30, 2018 2:51 AM

    Would a failover cluster (FCI) fulfil the brief for you?

    I'm not sure

  • August 13, 2018 at 9:59 pm

    #2001573

    This will not work with replication. Network & name issues that is.. 
    Maybe once you failover you can change the name and IP to match your primary.
    You should look for other options like evald suggested, clustering, log shipping, AG.
    If you use replication how will you failback? With standard edition you can do bi-directional transactional replication, P2P replication introduced in SQL 2005 but requires Enterprise Edition.
    I suggest staying away from replication as DR, very tricky to admin - unless you get a pro-DBA on staff - maybe find a Remote DBA at a fraction of the cost just to manage. Replication does provide almost active-active (online secondary) environment, but the admin overhead is a challenge.
    Best,
    ChrisBecker.blog

    Chris Becker bcsdata.net

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply