Setup: All machines run Windows Server 2008 Enterprise SQL Server 2012 Standard (Primary) SQL Server 2012 Standard (Mirror) SQL Server 2012 Express (Witness) Root issue: Our ASP.NET application is ...
Recently we had an issue with a sql server 2008 r2 HA mirror. I have tried to reproduce this in a lab environment and i came to the conclusion that i am missing something OR something is not possible. ...
Background/Context We are in the process of moving our SQL Server 2000 databases to a mirrored SQL Server 2008 R2 server with a witness and automatic failover. We have both .Net and Access ...
What are the differences between Mirroring and Failover Clustering and when is each one recommended over the other?
What are the main differences between Mirroring and Failover Clustering? What kind of problem each one solves and in what kind of scenarios is each one recommended over the other?