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