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:
It is a SQL database. WTF are you talking about managed or unmanaged?
There is no instance or location to run a script or do anything.
That's a managed SQL instance then.
You're only options with that are what Microsoft gives you.
-
@travisdh1 said in How can I backup an Azure SQL database to Backblaze B2:
You're only options with that are what Microsoft gives you.
There are methods to create backups (bacpac files), but obviously, something stored on the same location (cloud host) is not a valid backup in the event of host failure.
Why the hell is this such a hard thing to understand..
Now if the dumbass questions are done, can we get back to looking for an answer?
-
@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?
-
@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.
-
@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.
He has an Azure SQL Database, not a SQL Database on Azure. Azure itself provides only one thing, a managed SQL Server instance.
-
@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.
-
@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.
-
@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
-
@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
It's like signing the same piece of paper twice.
-
How about this one? Says it supports azure too.
https://sqlbackupandftp.com/blog/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.
