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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
12 views

Map an ADLS Gen2 storage to a a windows drive

A colleague of mine is claiming that it is not possible to map an Azure Data Lake Storage Gen2 store to a mapped drive in Windows. I'm not a specialist on this, but I'm very skeptical on this ...
mrgou's user avatar
  • 111
0 votes
0 answers
7 views

error when running OPENROWSET query - what to do with the FORMATFILE_DATA_SOURCE

I want to run a query from Sql server to Blob Storage all in the same Azure Tenant. my environment : SQL SERVER 2022 (running on a azure virtual machine) Blob storage. I've ran this scripts (some ...
dexon's user avatar
  • 47
0 votes
1 answer
54 views

What are recommended values for block size, buffercount and maxtransfer size for Ola backups to Azure?

I have SQL servers running on onprem and Azure VM hardware. The backups write to a file share located on a network VM. I am wanting to change the backup destination to Azure blob storage. For this I ...
variable's user avatar
  • 3,585
0 votes
0 answers
66 views

Backup SQL transaction log to Azure "append blob"?

We have long saved our hourly transaction log backups throughout the day by starting a new t-log file nightly, after the full backup is complete, and then appending to it hourly for the rest of the ...
OKreboots's user avatar
0 votes
1 answer
98 views

How to archive a on-premise sql server database to azure

We have an on-premise database of about eight terabytes that we are trying to archive to Azure. How can we go about it? This archive needs to be accessible because we might need to pull data from it ...
user avatar
0 votes
1 answer
381 views

How transaction is matched with read and write operations in BLOB storage (azure)?

In Azure Monitor, for particular blob in storage account we have the following metrics: ingress (GiB) engress (GiB) transactions (count) It looks like: I have a database which data and log files ...
gotqn's user avatar
  • 4,016
0 votes
1 answer
1k views

SQL Server - Access denied when reading a file from Azure Blob Storage container using SAS key

I have a requirement to read CSV files from an Azure blob storage. So far, this is throwing access denied errors every time I run my query: CREATE DATABASE SCOPED CREDENTIAL <myScopedCredential> ...
Dustine Tolete's user avatar
0 votes
1 answer
130 views

Restore from Azure Storage DB to sqlserver 2014

I am trying to restore the Database from Azure Storage to Sql server 2014 but getting the error "TITLE: Microsoft SQL Server Management Studio An exception occurred while executing a Transact-SQL ...
Saira's user avatar
  • 101
2 votes
0 answers
190 views

SQL Server 2014 SP3 Backup to URL error

We have a database on a SQL Server 2014 (SP3 12.0.6433.1) and I'm trying to take a backup to Azure Blob Storage. I have followed this document (https://learn.microsoft.com/en-us/previous-versions/sql/...
AzNerd's user avatar
  • 21
0 votes
0 answers
98 views

BACKUP LOG failed to write to Azure Blob

We have a SQL VM running out of Azure with SQL Agent jobs running BACKUP LOG every x hours to Azure Blob. These jobs have been running fine for a long time until recently. We keep getting the below ...
sydney's user avatar
  • 157
2 votes
1 answer
1k views

Sql server 2016 split url backup into multiple files

I have a database backing up into an Azure page blob via URL backups set up from SSMS. I am trying to find out how to split the backup into smaller chunks. I have a 2 TB database that is now backing ...
BriK's user avatar
  • 23
3 votes
2 answers
268 views

Backup files are lost while backing up to Azure URL from SQL Server 2016

I have a job script like this which should backup SQL Server 2016 dbs to Azure blob storage with storage key credential. Usually it works fine, but sometimes a few backups are lost (I mean there is no ...
igelr's user avatar
  • 2,132
1 vote
1 answer
2k views

SQL server restore from backup files on azure storage blob container (using SAS token)

I have set up a SAS token in an azure blob storage container. It is currently valid, as demonstrated by the fact that this command in windows cmd.exe works: azcopy list "https://<...
pygri's user avatar
  • 63
0 votes
1 answer
147 views

Azure blob storage - Access tier change

We currently have a legacy blob storage account of 600TB configured as Standard\Hot tier which has archived backups. As part of cost optimization, we want to change the access tier to Cool on the blob ...
yvr238's user avatar
  • 109
1 vote
0 answers
33 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 ...
Crogacht's user avatar
2 votes
1 answer
4k 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 ...
sydney's user avatar
  • 157
2 votes
2 answers
1k 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 below error when trying to do so. A nonrecoverable I/O error occurred on file "https://...
YaHozna's user avatar
  • 347
0 votes
0 answers
39 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 ...
Hosten's user avatar
  • 1
-2 votes
2 answers
107 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 ...
Manfred Beluga's user avatar
-1 votes
1 answer
310 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 ...
Abdallah Mehdoini's user avatar
0 votes
1 answer
834 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 ...
Austin's user avatar
  • 103
3 votes
1 answer
163 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 ...
GMassDBA's user avatar
  • 335
0 votes
1 answer
127 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 ...
Andres Arango's user avatar
1 vote
1 answer
524 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 ...
Eluros's user avatar
  • 75
0 votes
0 answers
113 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 ...
Pamela's user avatar
  • 1
1 vote
2 answers
97 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(...
Andres Arango's user avatar
2 votes
2 answers
689 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 ...
JohnC's user avatar
  • 133
1 vote
1 answer
111 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?
akeen's user avatar
  • 11
0 votes
1 answer
252 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 ...
Peter PitLock's user avatar
0 votes
1 answer
131 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, ...
SNR's user avatar
  • 139
5 votes
1 answer
1k 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 ...
dkw's user avatar
  • 51
1 vote
1 answer
4k 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 ...
user avatar
1 vote
1 answer
310 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 ...
MBender's user avatar
  • 113
2 votes
1 answer
1k 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'...
Adam Chandley's user avatar
1 vote
1 answer
275 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'...
Rainbolt's user avatar
  • 800
2 votes
1 answer
311 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 ...
Steve's user avatar
  • 21
2 votes
1 answer
761 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 ...
Craig's user avatar
  • 333
1 vote
1 answer
36 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 ...
Marcello Miorelli's user avatar
5 votes
1 answer
539 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 $(...
Marcello Miorelli's user avatar
2 votes
1 answer
3k 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": "...
SqlWorldWide's user avatar
  • 13.2k
1 vote
0 answers
2k 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 ...
JMB's user avatar
  • 51
2 votes
3 answers
241 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 ...
Feivel's user avatar
  • 507
0 votes
1 answer
273 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 ...
user3569267's user avatar
1 vote
2 answers
126 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 ...
Zapnologica's user avatar
2 votes
1 answer
1k 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 ...
Alocyte's user avatar
  • 420
2 votes
1 answer
238 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 ...
WhiskerBiscuit's user avatar
0 votes
1 answer
423 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 ...
nkdbajoe's user avatar
  • 194
1 vote
0 answers
550 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 ...
J.Norris's user avatar
1 vote
0 answers
568 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 ...
Andrzej Gis's user avatar
4 votes
1 answer
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 ...
user avatar