in the application layer we are giving the failover db instance name.
I like to understand if we failover db to the other instance rather which was mention in the application code will SQL NATIVE CLIENT will redirect the client to failed over db which was not mentioned in the application code?
2.In the application layer if i dont mention the failover db name, and due some bad failure in the server ,server went down. And there is mirroring setup and it has been manual failover.
Now how will application will connect to failured over server?since sql native is down on old priniciple server?
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.