How can I backup an Azure SQL database to Backblaze B2
-
@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-b2Looks like a good solution. I was hoping not to have to run a Windows instance someplace to do this though. But if nothing else, this definitely looks worth the price.
All of these solutions are API calls, so I was hoping it could be a service someplace.
-
@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:
@dbeato said in How can I backup an Azure SQL database to Backblaze B2:
@travisdh1 said in How can I backup an Azure SQL database to Backblaze B2:
@JaredBusch said in How can I backup an Azure SQL database to Backblaze B2:
@travisdh1 said in How can I backup an Azure SQL database to Backblaze B2:
That's a managed SQL instance then.
WTF? There is only one "type" of SQL database on Azure.. If this is managed, what the hell are you trying to claim would be unmanaged?
Ah, that explains a lot. I'd normally want to go look at options so I know WTH I'm talking about next time, but Azure.
Unmanaged would be MS SQL running on a host you manage. Weather that's a VPS, "cloud", or whatever.
It is like AWS RDS instances, which are usually not easily accessible but backups can be done easily to S3.
Again moving a dump to storage and than trigger an azure function seems the most feasible even if painful solution.
Btw azure sql should have multiregion backup. Isn't it?! This will prevent DC issues.
Not the issue. a backup on the same provider is not a backup
I still dont understand. It is multiregion. Quite good. It is not on the same physical machine it is distributed all around the world.
-
@matteo-nunziati said in How can I backup an Azure SQL database to Backblaze B2:
@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:
@dbeato said in How can I backup an Azure SQL database to Backblaze B2:
@travisdh1 said in How can I backup an Azure SQL database to Backblaze B2:
@JaredBusch said in How can I backup an Azure SQL database to Backblaze B2:
@travisdh1 said in How can I backup an Azure SQL database to Backblaze B2:
That's a managed SQL instance then.
WTF? There is only one "type" of SQL database on Azure.. If this is managed, what the hell are you trying to claim would be unmanaged?
Ah, that explains a lot. I'd normally want to go look at options so I know WTH I'm talking about next time, but Azure.
Unmanaged would be MS SQL running on a host you manage. Weather that's a VPS, "cloud", or whatever.
It is like AWS RDS instances, which are usually not easily accessible but backups can be done easily to S3.
Again moving a dump to storage and than trigger an azure function seems the most feasible even if painful solution.
Btw azure sql should have multiregion backup. Isn't it?! This will prevent DC issues.
Not the issue. a backup on the same provider is not a backup
I still dont understand. It is multiregion. Quite good. It is not on the same physical machine it is distributed all around the world.
If people here hadn't experienced Microsoft just deleting accounts, it might be acceptable. With the experience some (@scottalanmiller) have had, not so much.
-
@matteo-nunziati said in How can I backup an Azure SQL database to Backblaze B2:
@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:
@dbeato said in How can I backup an Azure SQL database to Backblaze B2:
@travisdh1 said in How can I backup an Azure SQL database to Backblaze B2:
@JaredBusch said in How can I backup an Azure SQL database to Backblaze B2:
@travisdh1 said in How can I backup an Azure SQL database to Backblaze B2:
That's a managed SQL instance then.
WTF? There is only one "type" of SQL database on Azure.. If this is managed, what the hell are you trying to claim would be unmanaged?
Ah, that explains a lot. I'd normally want to go look at options so I know WTH I'm talking about next time, but Azure.
Unmanaged would be MS SQL running on a host you manage. Weather that's a VPS, "cloud", or whatever.
It is like AWS RDS instances, which are usually not easily accessible but backups can be done easily to S3.
Again moving a dump to storage and than trigger an azure function seems the most feasible even if painful solution.
Btw azure sql should have multiregion backup. Isn't it?! This will prevent DC issues.
Not the issue. a backup on the same provider is not a backup
I still dont understand. It is multiregion. Quite good. It is not on the same physical machine it is distributed all around the world.
What do you do when the account is maliciously deleted?
What do you do when MS just cancels the service?
A backup on the same service is not a backup when that service goes away.
It is the same reason people purchase solutions to backup Office 365.
Are you going to throw out the 3-2-1 concept of backups entirely? You realize the 1 means one copy offsite right? In the SaaS world, offsite, means no on the same provider.
-
raid is not a backup
-
@Donahue said in How can I backup an Azure SQL database to Backblaze B2:
raid is not a backup
or RAIN or regional redundancy.
-
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.
