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.
51 questions
2
votes
1
answer
64
views
Is it possible to stripe backups going to Azure Blob Storage?
Using Ola Hallengren's toolset, I'm attempting do a backup of a database that is resulting in a backup that is larger than 1TB in size to Azure Blob Storage. This, obviously fails, so I attempt to ...
- 462
0
votes
1
answer
313
views
How can I manually backup a large Azure Flexible Postgres database?
I have a large (3TB+) single database on a Azure Postgres Flexible Server. This is a managed service, so it takes backups automatically and the frequency can be adjusted. As a disaster recovery/...
- 1
0
votes
1
answer
1k
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 ...
- 3,592
0
votes
0
answers
146
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 ...
0
votes
1
answer
156
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 ...
David ONAJOBI
0
votes
1
answer
515
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 ...
- 4,400
1
vote
1
answer
2k
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> ...
- 119
0
votes
1
answer
186
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 ...
- 101
2
votes
0
answers
296
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/...
- 21
0
votes
0
answers
142
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 ...
- 167
2
votes
1
answer
2k
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 ...
- 23
3
votes
2
answers
311
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 ...
- 2,172
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://<...
- 63
0
votes
1
answer
198
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 ...
- 129
1
vote
0
answers
49
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 ...
- 11