There are no brackets in the password.
From the help file, this is a sample that I was working from
master..sqlbackup '-SQL "BACKUP DATABASE pubs TO DISK = ''C:\\Backups\\pubs.sqb'' WITH PASSWORD = ''MyPassword'' " '
Alternatively, you can use square brackets instead of two single quotes:
master..sqlbackup '-SQL "BACKUP DATABASE pubs TO DISK = [C:\\Backups\\pubs.sqb] WITH PASSWORD = [MyPassword] " '
I did, however, do some further troubleshooting.
My actual password has an ascii 178(dec) or B2(hex) character in it which is a superscripted 2. This seems to be where the sqlbackup procedure is failing. When I create another backup without using this character, everything works in both the sql Command tool and the SqlBackup stored proc.
So it seems that the SqlBackup stored procedure has some difficulty with ascii characters above 122(DEC) or 7A(HEX) where the command line SqlBackupC command has no such issues.
It would be nice to see this limitation removed in a future release of SqlBackup.
BTW, I also got an exception in this post when I tried to use the actual character in the body of this message.