How can I backup an Azure SQL database to Backblaze B2
-
He wants his own backup / data copy of the Azure SQL database. Why's that so hard to understand?
Ya I remember hearing something about it on a Podcast. I'll try to find the right one and listen in again for it but probably not today.
-
@Pete-S said in How can I backup an Azure SQL database to Backblaze B2:
How about this one? Says it supports azure too.
https://sqlbackupandftp.com/blog/backblaze-b2$400 for lifetime updates. https://sqlbackupandftp.com/features
The also have a post about backup SQL on Linux, which means they are staying current.
http://sqlserveronlinuxbackup.com/backup-ftp-sql-server-linux/
-
when you go managed you have no way out...
Run a lambda or an instance seems the only way out. -
@matteo-nunziati said in How can I backup an Azure SQL database to Backblaze B2:
when you go managed you have no way out...
Run a lambda or an instance seems the only way out.If there was no way out, I would never do it. Just because you fail to grasp basic concepts does not make things like you think.
-
@JaredBusch said in How can I backup an Azure SQL database to Backblaze B2:
@matteo-nunziati said in How can I backup an Azure SQL database to Backblaze B2:
when you go managed you have no way out...
Run a lambda or an instance seems the only way out.If there was no way out, I would never do it. Just because you fail to grasp basic concepts does not make things like you think.
no way out remaining in the managed layer. when azure manages the db , it manages everything. In my googling there is no single documented feature to avoid local sync to integrate with third party cloud solutions at Azure SQL level. Going out of the SQL server into the OS let's things a bit simplier. The simpliest thing I would try is:
- let azure backup SQL in azure blobs
- run a linux instance
- mount azure blobs as per this doc
- use duplicity to backup the blobs data on backblaze as per this link
SQL Server has also stored procedures and a ton of programming level stuff, but this will turn everything into a more complex thing IMHO.
On the opposite azure functions are way simplier to run but quite limited in functionality. And still programming level stuff rather than sys admin stuff.
-
Just to ask the question as I do not have any Azure SQL systems that I touch or even look at.
There is a means to backup the database, correct? But that solution only saves the back on Azure and offers no means of pushing it to a different storage provider?
-
@JaredBusch said in How can I backup an Azure SQL database to Backblaze B2:
For what it's worth they also have a free version. Might be worth a test at least before you buy.
-
@DustinB3403 said in How can I backup an Azure SQL database to Backblaze B2:
Just to ask the question as I do not have any Azure SQL systems that I touch or even look at.
There is a means to backup the database, correct? But that solution only saves the back on Azure and offers no means of pushing it to a different storage provider?
Yep! Azure manages the DB server and the backups. then they are available in azure storage (blobs in my understanding).
-
@matteo-nunziati That's pretty bad design if there is no automated way to backup to a remote blob provider or to push said backups to said outside provider. . .
That $399 is sounding incredibly reasonable now.
-
@DustinB3403 said in How can I backup an Azure SQL database to Backblaze B2:
@matteo-nunziati That's pretty bad design if there is no automated way to backup to a remote blob provider or to push said backups to said outside provider. . .
That $399 is sounding incredibly reasonable now.
A main goal of any cloud service from major vendors is to lock in. Try to access a backup in GCP to export data: you can't.
I'm digging a bit to understand if the SQL backup in azure is accessible or managed by any infrastructure account which prevents users to access them directly...BWT, 399 lifetime is good.
