Azure SQL Database
An Azure relational database service.
6,326 questions
So you what to backup directly to Azure BLOB storage? How does your T-SQL command look like?
SQL Server error Event ID 3041 and 18204 troubleshooting
EnterpriseArchitect
6,041
Reputation points
I need some help in identifying and troubleshooting the SQL Server backup issue for my SQL server instance below:
Microsoft SQL Server 2019 (RTM-CU18-GDR) (KB5021124) - 15.0.4280.7 (X64)
The problem is that it always throws errors like the following:
- Event ID 3041:
BACKUP failed to complete the command BACKUP LOG model. Check the backup application log for detailed messages.
- Event ID 18204:
BackupDiskFile::CreateMedia: Backup device 'https://corporateaccount.blob.core.windows.net/azure-vm01/model_ad67e767efe673349523_20230807151537+10.log' failed to create. Operating system error 50(The request is not supported.).
Where to check the Backup settings and how to stop this from happening again?
Any help would be greatly appreciated.
Azure SQL Database
SQL Server Other
14,494 questions
2 answers
Sort by: Most helpful
-
Olaf Helper 47,436 Reputation points2023-08-07T06:33:32.06+00:00 -
EnterpriseArchitect 6,041 Reputation points
2023-08-07T06:41:05.9333333+00:00 HI @Olaf Helper ,
That's the mystery I am trying to resolve here as I am inherited this server and not sure where to start troubleshooting. -
EnterpriseArchitect 6,041 Reputation points
2023-08-07T06:44:28.4233333+00:00 Like this: I cannot see under the Backup Devices either.
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2023-08-07T21:22:02.4766667+00:00 "Backup devices" is a very old feature that few people use. I may be the only person who have used on this side of year 2010. Rather than saying
BACKUP DATABASE db TO DISK = 'somelongpath'you can define a backup device with sp_addumpdevice, and then say
BACKUP DATABASE db TO YourBackDeviceI don't think this work for backup to URL.
As for the error, I seem to recall this from when I played with backup to URL some time back. I think the issue in my case was that I had not set up the access to the blob store correctly. This article may help you: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-08-07T09:09:30.47+00:00 I found a similar thread, maybe you can use it as a reference: https://blog.sqlauthority.com/2018/08/23/sql-server-fix-backup-to-url-error-operating-system-error-50the-request-is-not-supported/.
Best regards,
Aniya
-
EnterpriseArchitect 6,041 Reputation points
2023-08-07T09:26:03.87+00:00 Hi @Anonymous ,
Where can I find this setting ?
-
Anonymous
2023-08-07T09:41:06.9+00:00 I don't know if what this thread describes is your error, but if you want to know about this setting, you can refer to this link: https://blog.sqlauthority.com/2018/07/17/sql-server-backup-to-url-script-to-generate-credential-and-backup-using-shared-access-signature-sas/.
Best regards
Aniya
Sign in to comment -