Azure – Azure Recovery now supports SQL 2019 and restore as file

Azure Recovery Services is keeping up with the latest release of Microsoft SQL, SQL Server 2019, as it now supports backing up SQL Server 2019 data running on virtual machine.

This also includes support for SQL Server 2019 running on Windows Server 2019.

In addition of this support, you also now restore SQL backup as a file (as .bak file – the famous SQL backup file type). This means no need to recover the full virtual machine anymore to recover a single (or more) SQL database and also this means you can then copy the .bak file to any other location to recover it using SQL Management Studio.

image_thumb

The recover as file still requires to target a ARS registered SQL Server anyway but you then define a path where the backup file will be recovered.

Benoit Hamet
Benoit Hamet
Benoit is working on Microsoft collaborative technologies He has been awarded as MVP for more than 12 years Currently MVP on Office 365 after being awarded on SharePoint (2011-2012) and Windows client & server (2002-2007) Speaker at various Microsoft events (TechDays, TechNet seminars) and Quest Software He works on on-premises (Active Directory, RADIUS/NPS, Exchange, Skype for Business, SharePoint, SQL, Terminal Server, Windows client and Windows Server) or online (Azure, Intune, Office 365, Exchange Online, SharePoint Online, Skype for Business Online, Teams) technologies