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?