How can I backup an Azure SQL database to Backblaze B2
-
And this is because you don't want the 35 days retention provided from Azure and you cannot use Long-term retention?
Maybe using exporting to a BACPAC file and then upload to B2?
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-export -
Paging @BackblazeNathan
-
@dbeato said in How can I backup an Azure SQL database to Backblaze B2:
And this is because you don't want the 35 days retention provided from Azure and you cannot use Long-term retention?
Because I want a backup
-
I've previously checked out their integration page, but nothing there is Azure.
I would prefer to not have to download it just to upload it, but I will if I have to.
-
@JaredBusch said in How can I backup an Azure SQL database to Backblaze B2:
I've previously checked out their integration page, but nothing there is Azure.
I would prefer to not have to download it just to upload it, but I will if I have to.
Am I correct in thinking this is one of the managed SQL instances?
-
@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:
I've previously checked out their integration page, but nothing there is Azure.
I would prefer to not have to download it just to upload it, but I will if I have to.
Am I correct in thinking this is one of the managed SQL instances?
No.
-
@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:
@JaredBusch said in How can I backup an Azure SQL database to Backblaze B2:
I've previously checked out their integration page, but nothing there is Azure.
I would prefer to not have to download it just to upload it, but I will if I have to.
Am I correct in thinking this is one of the managed SQL instances?
No.
So you can install different software on the box?
I don't remember seeing anything that has both MS SQL and B2 integration. What's keeping you from using any of the products that integrate B2 from pushing out the backup files from a MS SQL backup job?
-
@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:
@JaredBusch said in How can I backup an Azure SQL database to Backblaze B2:
I've previously checked out their integration page, but nothing there is Azure.
I would prefer to not have to download it just to upload it, but I will if I have to.
Am I correct in thinking this is one of the managed SQL instances?
No.
So you can install different software on the box?
What box? I clearly stated Azure SQL database. There is no box. No VM. Simply a database instance.
-
@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:
@JaredBusch said in How can I backup an Azure SQL database to Backblaze B2:
I've previously checked out their integration page, but nothing there is Azure.
I would prefer to not have to download it just to upload it, but I will if I have to.
Am I correct in thinking this is one of the managed SQL instances?
No.
WTF?! is this managed or unmanaged?! Btw you can try lambdas and b2 rest api if you are brave... I think they call lambdas something like azure functions
-
@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:
@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:
I've previously checked out their integration page, but nothing there is Azure.
I would prefer to not have to download it just to upload it, but I will if I have to.
Am I correct in thinking this is one of the managed SQL instances?
No.
WTF?! is this managed or unmanaged?!
This.
-
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.
-
@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.
