Share on Facebook0Share on Google+0Share on LinkedIn0Share on Reddit7Tweet about this on Twitter0

https://i1.wp.com/cloudyjourney.fr/wp-content/uploads/2018/01/ASRLogo.png?ssl=1

Microsoft released a few weeks ago a new feature, to backup your SQL Server databases, directly from Azure Backup. You’ll be able to find more information about prerequisites and limitations here : https://docs.microsoft.com/en-us/azure/backup/backup-azure-sql-database

Backup

To start, open your vault, and choose SQL Server in Azure VM instead of Virtual Machines. As you can see, because VMs are deployed manually and not through the marketplace, I need to do manually some actions. Select a VM that contains a SQL Server :

https://i1.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL01.png?ssl=1

An extension will be deployed on each VM, to access databases :

https://i0.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL03.png?resize=1024%2C148&ssl=1

An error message will appear, to give you the instruction to add sysadmin rights, on instances that you want to backup, to the account created during the installation of the extension, NT Service\AzureWLBackupPluginSvc:

https://i1.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL02.png?ssl=1

Error Code : UserErrorSQLNoSysadminMembership
Error Message : Azure Backup service creates a service account “NT Service\AzureWLBackupPluginSvc” for all operations and this account needs SQL sysadmin priviledge.
Recommended Action : Please provide SysAdmin privileges to AzureWLBackupPluginSvc.

https://i0.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL04.png?ssl=1

When it’s done, relaunch the scan of instances to discover databases :

https://i1.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL05.png?ssl=1

Databases have been discovered correctly :

https://i1.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL06.png?ssl=1

Click now on Configure Backup :

https://i2.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL07.png?ssl=1

And choose databases to backup :

https://i1.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL08.png?ssl=1

Choose a policy to backup logs :

https://i1.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL09.png?ssl=1

Our databases have been added to the backup successfully. Click on it to access them :

https://i0.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL10.png?ssl=1

Choose a database and start a Full backup :

https://i0.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL11.png?ssl=1

All full backups worked correctly :

https://i1.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL12.png?ssl=1

StarWind Virtual SAN eliminates any need for physical shared storage just by mirroring internal flash and storage resources between hypervisor servers. Furthermore, the solution can be run on the off-the-shelf hardware. Such design allows StarWind Virtual SAN to not only achieve high performance and efficient hardware utilization but also reduce operational and capital expenses.
Learn more about ➡ StarWind Virtual SAN

Restore

To restore a database, go on the database that you want to restore, and click on Restore. You can create a new database based on the backup, et replace the current database :

https://i2.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL13.png?ssl=1

Select a restore point :

https://i2.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL14.png?ssl=1

And where to restore this database :

https://i1.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL15.png?ssl=1

Restore of the database is in progress :

https://i1.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL16.png?ssl=1

The database has been restored correctly :

https://i0.wp.com/cloudyjourney.fr/wp-content/uploads/2018/08/AzureSQL17.png?ssl=1

This new functionality is very interesting and is working smoothly for a preview. Adding of other databases types like Oracle, MySQL, PostGre, etc. could be very interesting.

 

Views All Time
9
Views Today
17
Appreciate how useful this article was to you?
1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
5 out of 5, based on 1 review
Loading...
Back to blog
The following two tabs change content below.
Florent Appointaire
Florent Appointaire is Microsoft Engineer with 5 years of experience, specialized in Cloud Technologies (Public/Hybrid/Private). He is a freelance consultant in Belgium from the beginning of 2017. He is MVP Cloud and Datacentre Management. He is MCSE Private Cloud and Hyper-V certified. His favorite products are SCVMM, SCOM, Windows Azure pack/Azure Stack and Microsoft Azure.