Post reply

Issues with SQL backups due to Nodes returning multiple IPs

  • December 9, 2018 at 10:23 am

    #376589

    We have a four node cluster (SQL Server 2014 on windows 12) and we recently setup heart beat network on the nodes following a best practices source after experiencing some cluster instability issues. Ever since couple secondary nodes are returning multiple IPs in the DNS. We have set the following settings and removed the entries from the DNS server for both the nodes multiple times but the IPs of the heartbeat network (the IPs are supposed to be non-routable) keep popping ultimately returning two Ips for the same node and this is causing issues with our backups. I have checked the settings on all 4 nodes and they are the same in the network adapter properties. What am I doing wrong?

    --Pra:-):-)--------------------------------------------------------------------------------

  • December 10, 2018 at 9:40 am

    #2015901

    Just to check, are the IP addresses for the private network on a separate subnet from the public addresses?  After that, all I can think of is WINS is trying to be helpful, but that is unlikely.

  • December 10, 2018 at 10:32 am

    #2015913

    when you assign IP address it is going to be there, heart beat or public network doesn't matter, use host file on your backup server and see if it helps.

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

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