#Azure #PowerShell Corner: Backup #SQLServer to Azure Storage

By | January 24, 2015

Something a little different today.

Since SQL Server 2012 SP1 it has been natively supported to run a disk backup of databases and logs directly into Azure Blob storage.

For organisations with on-prem SQL Servers but a desire to improve their backup capability by using the safe, secure Azure platform, this functionality is a dream come true despite the fact that no SSMS support was initially provided.

Fortunately, the PowerShell provider and cmdlets for SQL Server introduced in 2012 make it easy to leverage the capability.

Here’s a quick and dirty way to backup all of your databases in a given instance.

Why is it quick and dirty? You can tidy it up, you might even learn something… 🙂

Usual caveats apply – think before you execute!

more to follow…

Leave a Reply

Your email address will not be published. Required fields are marked *