When SQL Server 2008 R2 is setup with two servers that are in an automatic failover configuration, what happens when you fail over the database?
We have a web app that we need to be highly-available... does the mirror server take over the principal server's IP for queries? How does this work? Do they share an IP that sends queries to the right server? What happens?
I can't find any info on this. Let me know!