Unable to Back Up MS SQL Database to Azure Blob Container

  Kiến thức lập trình

When attempting to backup our MS SQL Database to our Blob container we get the following error:

TITLE: Microsoft SQL Server Management Studio

Backup failed for Server ‘xxxxxxxxx’.
(Microsoft.SqlServer.SmoExtended)

For help, click:
https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.200.48053.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

—————————— ADDITIONAL INFORMATION:

Microsoft.Data.SqlClient.SqlError: The file name “xxxxxxukssbox01/xxx_backup_2024_04_17_160840.bak” is invalid as a backup device name for the specified device type. Reissue the BACKUP statement with a valid file name and device type. (Microsoft.SqlServer.Smo)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.200.48053.0&LinkId=20476


BUTTONS:

OK

Can someone let me know why SSMS isn’t happy with the filename?

LEAVE A COMMENT