Production DBA
How to Back Up SQL Server to Azure Blob Storage
When you’re planning for disaster recovery, offsite backups in the cloud are an attractive option. SQL Server Management Studio makes it easy to back up to the cloud inside the GUI, and you can learn how in just 90 seconds:
Update March 12 – if you want a better end result than what I get in the video, check out this T-SQL method from Steve Thompson.
Free, 3× a week
Get my new posts by email
Three posts a week, plus a Monday roundup of the best database news from around the web.
Marvelous, Sir.
Ha! If you don’t succeed try and try until …thats it for us folks!
Thank you so much! I had been wondering about the specific steps needed. We are off to the races now!
$2 on BlueNose in the third.
Simply tremendous. That cleared away a lot of my doubts.
Really funny. I watched with anticipation and fell into your trap.
That was the best! Those Microsoft accounts always get me. I have to remember too much context to know if I use my personal account or work account. Maybe they are using that technique it a two factor authentication. 🙂
Now I have your password. Muhahahahaha
Brent in full ‘Barry White voice’ mode.
Yeah, it really threw me for a few seconds!
HAHAHA, it’s true. When I hear my voice on the headphones, I go a little over the top, heh.
Probably better for this to happen on the backup dialogue than the restore dialogue, huh.
Hahaha, that’s true too.
I’m betting it’ll happen there as well. Which would be a problem if he got it successfully set up on one system and then someone else had to do it on another.
Working as intended.
Hilarious.
The script error is particularly lovely!
FWIW, we use Microsoft’s “SQL Server Backup to Windows Azure” which ‘appears’ to create standard local backups, but actually just stores a little stub of JSON in the ‘.BAK’ file, and all the real data in blob storage. And (brace yourself) … it works really well!
Brent, it is just brilliant:)
Mazal tov:)
Marvelous! And so reminiscent of many of my interactions with the Microsoft security. I burst out laughing. Perfect for April fool’s day!
Hi all,
I’d like to know if is possible to backup in multiple places.
For example: In a BLOB and in a network share at the same time.
I’m using Maintenance Solution scripts from ola.hallengren.
Thanks,
Bruno
For support with Ola’s scripts, contact Ola.