SQL Server HA and DR Solutions
The following are the most commonly used HA and DR solutions available in Microsoft SQL Server.
Windows Server Failover Cluster Installation
Commonly known as FCI, this requires SQL Server to be installed as a cluster service on top of the Windows failover cluster.
The SQL Server service is managed by a Windows cluster resource. The example we took to explain HA and DR earlier in this lesson was largely based on this.
This book covers creating a Windows Server Failover Cluster; however, it doesn't cover troubleshooting a failover cluster.
Log Shipping
Log shipping is one of the oldest SQL Server solutions, and is mostly used for DR and SQL Server migration. It takes transaction log backups from the primary server and restores them on one or more secondary servers. It is implemented using SQL Agent jobs.
Log shipping is covered in more detail later in this book.
AlwaysOn Availability Groups
Introduced in SQL Server 2012, AlwaysOn AG is one of the newest and most...