Ask 10 people 'What is high availability?' and you might get 15 different answers. For the purposes here, HA will be defined as ensuring SQL Server is operating when and as needed. 'When' takes into ...

In-Depth Tour de SQL Finale, Part IV: Replication Our final sprint to the finish line stretches over replication: its limitations, high availability and the many improvements since the last version.

These software-only solutions facilitate, at a minimum, real-time data replication, continuous monitoring able to detect failures at the application level, and configurable policies for failover and ...

Whether you are an Oracle or SQL Server DBA, late night calls, production database crashes, planned and unplanned downtimes are painfully common. Discover how Quest SharePlex provides you best in ...

Exchange Server 2010 incorporates a number of high-availability features that system admins will find useful, including a new database availability groups (DAG) feature.

You could look into some kind of replication scheme as well, but this would need application support as well. You can look into Distributed Availability Groups to handle the difference in location.