Im trying to implement log shipping using Backup-sqldatabase command, but
SqlCredential is a required parameter for Azure Storage uploads according to the docs. However, im using a Shared Access Token credential, so i can't really use the
SqlCredential parameter. If i do, this is the error i get:
Backup-SqlDatabase : System.Data.SqlClient.SqlError: Use of WITH CREDENTIAL syntax is not valid for credentials containing a Shared Access Signature.
Does this mean that SAS tokens/credential CANT be used for
If i dont include the
SqlCredential parameter, i get this error:
Backup-SqlDatabase : System.Data.SqlClient.SqlError: The file name "https://xxxxdev.blob.core.windows.net/DESKTOP-MCxxxx-MSSQL15.MSSQLSERVER-Test123-132767637897201085.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.
Test123 is just a random test database i created on localhost for testing purposes
Also, is there a powershell script in place that performs logshipping completely with Azure Blob Storage integration? i have been searching and the only thing that is close to what im looking for is dbatools, but
Invoke-DbaDbLogShipping requires a backupnetwork drive, so I think Azure Blob Storage cannot be used at this time unfortunately :/