Delphix Products

 View Only
  • 1.  SQL Server HA Environment / dSources

    Posted 11-29-2018 12:21:00 PM
    Good Day ,

    Scenario: I have a SQL Server AG setup  , replicated databases to Secondary Node and those database on Primary must be ingested into Delphix Engine. 

    Quick One: Which IP / DNS Name must i register to Delphix Engine?
     AG Listener ?

    Definitely Primary Node Server name wont be ideal .


  • 2.  RE: SQL Server HA Environment / dSources
    Best Answer

    Posted 11-29-2018 01:12:00 PM

    You can use databases on Windows Server Failover Clusters (WSFC) as data sources. Add the environment as described below, based on which WSFC feature the source databases use:

    • Failover Cluster Instances
      Add the environment as a standalone source using the cluster name or address.
    • AlwaysOn Availability Groups
      Add the environment as a cluster source using the cluster name or address.

    If using a Failover Cluster or AlwaysOn data source, the cluster configuration must also meet the following requirements:

    • The fully qualified Cluster Name (part of the cluster's Core Resources) must be known to the DNS server used by the Delphix Engine
    • The validated sync environment must be able to resolve the Cluster Name using the Cluster IP address (perform a reverse DNS lookup)

    More details here:

  • 3.  RE: SQL Server HA Environment / dSources

    Posted 02-05-2019 12:32:00 PM
    Good Day ,

    I only managed to add WSFC Cluster DNS Name , source and standalone and only non-AG databases are visible.

    I assumed i can do WSFC IP Address / DNS Name , source and cluster. The system complains : Exception calling "GetHostEntry" with "1" argument(s): "No such host is known" .

    I can ping my WSFC Ip address and do a nslookup.