Hey Wayne, thanks for telling me about this. It's already been fixed and is ready to go in the upcoming service release.
Okay, here's another one for you. :)
Bug in BackupDB.
Replace
Command VARCHAR(4000) COLLATE DATABASE_DEFAULT,
with
Command VARCHAR(MAX) COLLATE DATABASE_DEFAULT,
at line 1432 to avoid truncation of very long backup commands.
Ok, I'll take a look at it and see if that's already in the service release.
Another bug in BackupStmtGet. :)
In Minion.BackupStmtGet, around line 1977, add this to the IF statement that tests for @BackupLocType = 'URL' [and ISNULL(@AzureCredential, '') <> '']
Reason: if backup is using Shared Access Signature to backup to Azure Blob storage, no CREDENTIAL is necessary or should be supplied, but it currently appends [,CREDENTIAL = ''] to the end of the backup statement anyway.
Y that didn't exist when the SP was created. I'll make sure that gets added. Thanks.
Wayne Clemmer
three lines where
SET @DBSize = (SELECT CAST(Size/1024.0/1024.0 AS DECIMAL(5,2)) FROM #DBSize);
you can get errors for large databases.
Replace the 5 with a 7 to fix.