Y that didn't exist when the SP was created. I'll make sure that gets added. Thanks.
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.
Ok, I'll take a look at it and see if that's already in the 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.
Hey Wayne, thanks for telling me about this. It's already been fixed and is ready to go in the upcoming service release.
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.