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 ...

Microsoft SQL Server has become a business-critical database for a growing number of enterprises that rely on it to run a wide range of essential business processes. As enterprises look to ...

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.