Does SQL cache linked server destination IPs?

• TangoVictor

  SSChampion

  Points: 10976

  More actions

  July 26, 2022 at 4:47 am

  #4068184

  We use DNS aliases in our linked servers that point to the server where each database lives.

  Tonight we moved some databases to new servers. TTL was set to 1 minute before the DNS aliases were changed to the new hosts.

  There was a view on a separate server that referenced a moved database via DNS in a linked server and it kept trying to go to the old server even after an nslookup on that SQL Server showed the correct location.

  I'm thinking linked servers cache their destination IP or something. Does anyone know if this could be the case?

  How could it possibly ignore what DNS was telling it for the location?

  I dropped and recreated the linked server and then it worked fine. Curious if anyone has any thoughts on this. Thx

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  July 27, 2022 at 5:10 am

  #4068737

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.