As I understand it if you are using mirroring on SQL server and have failover setup you can adjust the connection strings of your applications that use it so they ...

We've had SQL 2005 mirroring running successfully for a while now, but the issue I have is our applications reference the primary server by name directly and when the mirror fails over to box #2 I'm ...

The automatic failover feature was provided by a third SQL Server instance, in addition to the Principal and the Mirror, which was called the Witness. When the Principal was having trouble, the ...

While the cloud continues to grow in popularity for many, if not most, enterprise applications, IT departments remain reluctant to trust public clouds, including the Google Cloud Platform, for ...

DBAs have many options for how to ensure high availability (HA) for SQL Server. Some of these options are available in the different versions and editions of SQL Server itself. Some are available in ...

I have been testing out Database Mirroring in SQL Server 2008. There are numerous enhancements in 2008, mainly under the hood in the name of performance and reliability but still worth testing out. I ...

A step-by-step guide to using SAN-less failover clustering software to support SQL Server’s Always On Failover Clustering in the public cloud The thing about clouds is that they can change shape even ...