With Extended Support for SQL Server 2008 and SQL Server 2008 R2 ending in July 2019, to be adopted six months later by the top of Extended Support for Windows Server 2008 and 2008 R2 in January 2020, the clock is ticking on making modifications to sure legacy purposes. Upgrading to the most recent variations is all the time an choice, however Microsoft is offering another when upgrades should not viable: Migrate the purposes to the Azure cloud to get three extra years of free Extended Security Update help.
Microsoft’s provide: “Customers who migrate workloads to Azure virtual machines will have access to Extended Security Updates for both SQL Server and Windows Server 2008 and 2008 R2 for three years after the End of Support deadlines, included at no additional charge over the standard VM pricing.” To help with the migration, Microsoft permits current on-premises licenses to be transferred to the Azure cloud, and likewise affords a 180-day transition interval throughout which a single license applies concurrently on-premises and within the cloud.
For these legacy SQL Server 2008/R2 purposes that stay vital, some type of excessive availability or catastrophe restoration safety might be required to protect enterprise continuity. It is feasible to completely shield these legacy purposes within the state-of-the-art Azure cloud, in fact, however that requires understanding and correctly configuring the mandatory provisions. And with decade-old software program, getting it proper could be considerably difficult.
This article supplies an outline of the excessive availability (HA) and catastrophe restoration (DR) provisions accessible for SQL Server 2008/R2 within the Azure cloud and highlights two frequent HA/DR configurations. It is necessary to notice that the provisions mentioned right here additionally apply to later variations of SQL Server and Windows Server, making them appropriate for different purposes, together with any legacy ones being upgraded. Any variations among the many completely different variations might be famous.
