Questions tagged [azure-blob-storage]
Azure Blob Storage is persistent cloud-based storage provided by Microsoft. Use this tag for questions *about* either how-to-use or problems using Azure Blob Storage.
40
questions
0
votes
0answers
14 views
Can you bulk upload a file from a remote server to a Azure Managed server
I have a .NET app on a remote server that downloads and processes a file which it then saves to disk, this file is then bulk inserted by SQL and further work carried out. This works a treat when ...
0
votes
0answers
12 views
Azure data factory - ON CONFLICT DO NOTHING
I am building a data pipeline with Azure data factory with source from Azure storage account where the data is in json files and sink as a postgresql database.
My json files will contain data that ...
1
vote
0answers
18 views
Azure VM SQL Server Automated Backup doing log backups only
We have an Azure VM running our own copy of SQL Server 2019, and we have just configured the Automated Backup functionality.
I have it configured like this:
Everything seems to be fine, except for ...
1
vote
1answer
148 views
Azure Block Blob Limitation
Recently I ran into an error when I tried to backup a database to Azure Blob storage. The error was this:
1117(The request could not be performed because of an I/O device error.)
The database .mdf ...
1
vote
2answers
86 views
Error when backing up from SQL Server 2014 to Azure blob storage
I'm trying to back up a SQL Server 2014 database to Azure blob storage however I'm getting the following error when trying to do so:
A nonrecoverable I/O error occurred on file
"https://...
0
votes
0answers
17 views
PostgreSQL for user management and another database for file management (Blob storage)
I am working on a project with video hosting and online editing platform with a microservice architecture in mind.
One of my teammates uses PostgreSQL SQL for user management, but I need to handle ...
0
votes
0answers
6 views
Fetching content binary from database or fetching content by its link from storage service
For an app (web + phone) there are two options:
Image binaries in database. Server replies to app HTTP request with images as base64
Images in storage service like Amazon S3 or Azure Blob Storage or ...
-2
votes
2answers
43 views
Which serverless database to store user data and images?
I am designing a cloud deployed system where users can log in and upload some user-specific images (not super large files, but maybe sometimes >1mb that are then later displayed in the system to ...
-1
votes
1answer
67 views
How does sql server agent access the azure storage blob [duplicate]
Good morning all ,
I must configure an automated backup to an azure blob storage
in the backup script I have correctly configured the credential
now what right is needed for the sql server agent ...
0
votes
1answer
212 views
Storage accounts not showing up when creating Azure Storage Credential
I'm trying to setup a Back Up Database Task in a Maintenance Plan on SQL Server 2017 (Web Edition) using SSMS 18.6 and when I get to the step to create an Azure credential I select my management ...
3
votes
1answer
73 views
how to mirror an azure storage account to a non-paired zone to enable fast file_snapshot backup/restore and database file access?
Wow, that title was a mouthful.
Scenario
My dev server is restoring a copy of production data daily, anonymizing it, and creating a dev-grade backup for my developers to restore locally. We're running ...
0
votes
1answer
65 views
Automated backups sql server IaaS
We have installed sql server on a virtual machine and we have registered the machine so that way SQL Server IaaS Agent Extension (SQLIaaSAgent) gets enable and runs on Azure virtual machines to ...
1
vote
1answer
142 views
Speed-- Restoring from Azure Blob to local database
We're being encouraged to move our database backups to Azure blobs, which we access through the Microsoft Azure Storage Explorer. We're running SQL Server 2017.
Our backup times are fine-- 20 minutes ...
0
votes
0answers
20 views
Error when trying to bakup from SQL Server 2012 to Azure
I'm trying to do a backup from SQL Server 2012 to Azure (free account), but I'm getting this error:
'URL' is not a recognized Device Type option
I´m writing the instruction like this:
BACKUP ...
1
vote
1answer
30 views
Backup with date to azure blob storage url
Im trying to do backups to an azure blob storage that have the date when the backup is made, that way the job does not fail when the backup is generated with the same name, I am concatenating convert(...
2
votes
2answers
409 views
Azure blob storage container vs VM managed disk for SQL on Azure VM database files
Are there benefits specific to SQL Server on Azure VM when using the SQL Server Data Files in Windows Azure feature? Aka using Azure blob storage container for database files versus an Azure VM data ...
1
vote
1answer
61 views
Setting up sp_AllNightLog using Azure Blob Storage [closed]
Has anyone setup Brent Ozar's sp_AllNightLog using Azure Blob Storage? Trying to start incorporating both but not sure of the steps or how to get started. Any tips or links to similar operations?
0
votes
1answer
117 views
Back up Full Recovery Model Without Log Backups
I have a database that I need to backup to URL, but without the log file.
BACKUP DATABASE [MyDB] TO URL = @destination
WITH INIT, FORMAT, COPY_ONLY, CREDENTIAL = '', stats=1
The above script ...
0
votes
1answer
77 views
How to Backup to Azure Storage?
A day before I tried to back up our ddbb log file to azure storage. So, the transact is simple
backup [log|database] <name>
To URL = <Azure_Storage_url>
Credentials are defined apart,
...
5
votes
1answer
702 views
Managed backup large database to Azure
Got a bit of an issue here that I need some help to solve.
Hosting a database, that is about 400Gigs. This is giving us a little headache getting it to work with Managed Backup to Azure Storage ...
1
vote
1answer
3k views
Parameter value in Data Factory Triggered pipeline
I have a pipeline configured in azure data factory which basically does create a backup file (JSON) from a cosmosDB dataset and it's saved in a blob storage, my problem comes when I want to schedule ...
1
vote
1answer
277 views
SQL Server backup to Azure Blob with different backup plan than local backup
We have a production SQL Server with a number of critical bases. At this time, we have a maintenance plan which performs the following:
creates a FULL backup every Saturday with a TTL of 4 weeks
...
2
votes
1answer
914 views
Ola Maintenance Solution and striped Azure URL backups - possible?
We've been using the defacto standard Ola Hallengrin maintenance solution for many years, even after we moved to Azure and started using blobs for backup targets. However, for performance reasons, I'...
1
vote
1answer
174 views
How do I initialize transactional replication from a backup at a URL?
I created a publication on my server. I had to use this special option so that I could initialize replication from a backup:
exec sp_addpublication
...
@allow_initialize_from_backup = N'true'...
2
votes
1answer
214 views
Dynamic Folder Creation when Backing up to Azure BLOB Storage [closed]
Is there a way to dynamically create folders in BLOB so each DB goes into its own folder? I know in Azure BLOB Storage they are not real folders, but I hope you get my point. In essence I am using ...
2
votes
1answer
643 views
Differential Backup from SQL Server 2012 to Azure Blob
I am attempting to backup a database to my Azure Blob storage. The databases are relatively large... between 1 and 30 Gig.
I have successfully backed up the first day, but on subsequent days, I get ...
1
vote
1answer
26 views
Is there a way to set an order to the way files are available in Azure? I want the latest backup first
I use Azure to store backups, the backups are saved in Azure.
this is how I am doing my backups and saving to azure:
sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master
-Q "EXECUTE dbo.DatabaseBackup ...
5
votes
1answer
527 views
How to connect to microsoft azure?
We have been saving the backups of one of our production servers (which is actually an Always On availability group)
this is how I am doing my backups and saving to azure:
sqlcmd -E -S $(...
2
votes
1answer
2k views
Azure Data Factory 'Failed Validation' with Folder does not exist
I uploaded whole set of .txt files in my blob storage with folder structure Year/Month/day.
I circled the folder structure.
Then in the pipeline I have following dataset created.
"type": "...
1
vote
0answers
1k views
SQL backup to URL failures on Azure Storage
I have been using SQL Backup to URL to backup databases in the range of 100-400 GBs on SQL Server 2012 SP3. Intermittent failures have become increasingly common that I am now experiencing a failure ...
2
votes
3answers
228 views
Backing up databases on SQL Server hosted in Windows Azure VM
One of the clients at my workplace asked me to find out information on what would be the best possible or recommended approach to run maintenance jobs such as backup job for a SQL Server 2016 hosted ...
0
votes
1answer
168 views
copy backup from azure blob
has anyone a sql script that allow us copy the last full backup files from azure blob container to an ftp server or simply to the machine from which we run the script (sql server machine)?
Thanks in ...
1
vote
2answers
109 views
Database Technology for Large Scale Logging [closed]
I am stuck looking for a suitable database technology to suit our application. I am stuck between going cloud-based or keeping it local.
Scenario:
We have a service that receives a log stream for ...
2
votes
1answer
811 views
Backup to Azure Storage Container: Shared Access Signature the only way?
RESTORE FILELISTONLY FROM URL = '' WITH CREDENTIAL = '' fails in SQL Server 2016.
Copied script from SQL Server 2012 environment, successfully restoring from Azure Storage Container, with create ...
2
votes
1answer
224 views
Developing an Azure Sql Database backup strategy [closed]
I know Azure databases are backed up and kept for a retention period, which I believe the default is 30 days. I'd like to come up with a plan to mimic our current strategy with a physical SQL Server ...
0
votes
1answer
404 views
Setup Managed Backup failure
I am trying to setup Managed Backup (in Azure SQL) using SQLServer 2014 (Ent 64bit) and it is failing.
I have the credential created with Identity as the Storage account name and Password set with ...
1
vote
0answers
468 views
SSMS Crashes when attempting to restore DB from Azure URL
I'd previously been using the April 2016 version of SQL Server Management Studio with no issues, but have run into problems since updating to the GA June 2016 version of SSMS. When I try to restore a ...
1
vote
0answers
489 views
How to restore SQL Server database from Azure Blob?
I created a database (IaaS) from Azure marketplace (Windows server 2012 + SQL Server Web 2014). I Selected automatic backups to blob storage. Now I'm trying to do a test restore operation.
I imported ...
4
votes
1answer
1k views
Managed backup to Azure does not delete backup after retention period
I did set up SQL Server managed backup for our databases. I did define retention days to 4, but i just checked the azure storage account where the managed backups are and found that there is still all ...
3
votes
1answer
669 views
RESTORE FROM URL dies during database recovery
Attempting to restore a small backup from the Azure BLOB
RESTORE DATABASE MY_DATABASE FROM URL = 'https://somelocation.blob.core.windows.net/mydatabase.bak'
WITH FILE=1
,MOVE N'MY_DATABASE'TO N'D:\...
