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?
Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.