This is a guest post by Debra Shinder, also included in virtualization.info’s Tech Talks section.
Your SQL server database most likely holds some of your business’s most important mission-critical information, the loss of which could be catastrophic. You undoubtedly back up that data regularly – but if you’re keeping those backups on premises, a natural disaster such as a tornado or flood or explosion could still leave you in the lurch.
One big advantage of the cloud is that it makes it easier than ever to make and maintain off-premises backups that will be safe even in the face of such a calamity. In a Windows shop, Microsoft Azure is frequently the “cloud of choice.” Microsoft Azure can be the basis for your business continuity plan.
If you have a Microsoft Azure subscription with an Azure Storage account, you’re good to go, but there are a few things that you’ll need to do in order to enable backing up your SQL server databases to the Azure cloud. Blobs are one of the three types of data that you can store in Azure Storage. What you need to do now is log into the Azure Management Portal and create a Microsoft Azure Blob Storage container.
Now luckily, you don’t have to figure out how to copy the SQL data to your Azure Blob Storage container manually, because Microsoft provides tools that simplify the process. If you’re running Microsoft SQL Server 2014, you have it made. You can use the Managed Backup to Microsoft Azure tool in the SQL Server Management Studio.
Read more