Azure Backup for SQL Server 2008 Available at Preview Stage -- Redmondmag.com

Azure Backup for SQL Server 2008 Available at Preview Stage

By Kurt Mackie
06/21/2019

Microsoft added the option of using the Azure Backup service to provide recovery support for SQL Server 2008 and SQL Server 2008 R2 when those workloads are hosted on Azure virtual machines.

The Azure Backup support for those versions of SQL Server is currently available at the preview stage, according to a Thursday Microsoft announcement. Other Microsoft recovery options include the use of "log shipping" (creating a SQL Server replica in another Azure zone or region) and use of the Azure Site Recovery service to replicate virtual machines between regions and zones, according to this Microsoft document description.

Microsoft's announcement of the preview was apparently targeted toward organizations moving their SQL Server 2008 or SQL Server 2008 R2 instances to Microsoft's Azure datacenters.

SQL Server 2008 and SQL Server 2008 R2 will fall out of support on July 9, 2019. Losing support means that no more software patches will arrive, including security updates. However, Microsoft introduced an Extended Security Updates Program last year for those servers, as well as Windows Server 2008. The Extended Security Updates Program will extend patch support for those servers for three more years past the product end-of-life dates. The patch support is "free" if the servers are hosted in an Azure virtual machine, although organizations still need to pay monthly costs to use the virtual machine.

Microsoft's announcement was a reminder that there's no free backup support for organizations going the Extended Security Updates Program route.

"Of the available migration options, if you choose to lift and shift your on-premises SQL Server to an Azure virtual machine as-is, you will still need to manage backups," explained Swati Sachdeva, program manager II for Azure Backup, in the announcement. She added that Azure Backup can be used instead of having to move a legacy backup solution to the cloud.

The Azure Backup service for SQL Server reached "general availability" commercial status back in March. Apparently what's new now is that Microsoft has added support for the older SQL Server 2008/R2 products, even as they are now approaching the end of their product lifespans.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.

Featured

Using Configuration Files to Control PowerShell Scripts, Part 2: Building Blocks

Learn how to use PowerShell's GUI capabilities to dynamically create configuration files that enhance script flexibility and usability.
U.S. House Leaders Unveil Bipartisan Strategy for AI Governance and Innovation

On Tuesday, U.S. House Speaker Mike Johnson and Democratic Leader Hakeem Jeffries received the final report from the bipartisan House Task Force on Artificial Intelligence, which outlines essential principles and recommendations to bolster American leadership in AI.
Using Configuration Files to Control PowerShell Scripts, Part 1: The Basics

Learn how to use JSON configuration files to make PowerShell scripts more dynamic, flexible and user-friendly.
Exchange Online Receiving Enhanced Message Trace

Microsoft has announced the public preview of its enhanced Message Trace feature in the Exchange admin center (EAC) for Exchange Online.
Major Microsoft Multifactor Authentication Vulnerability Revealed

A vulnerability in Microsoft’s multifactor authentication (MFA) system has been uncovered by cybersecurity firm Oasis Security, allowing attackers to bypass security measures and access sensitive data across services including Outlook, OneDrive, Teams and Azure.