Cannot restore backup because I used square bracket in encryption password

rackl001

We are running SQL Backup 6.5.1.9. I cannot restore my backup using the GUI because I used a square bracket in the encryption password. I understand that I might be able to restore using a command. Can anyone provide me with the restore command? I would be most appreciative.

My password contains the ] as the last character.

rackl001

Thank you for your reply, Dan. We have already restored from a different SQL backup. I will save your reply for future reference --- which I hope I will never need again. I have already changed the encryption password in our backups.

Dan B

Hi Rackl001,

This depends what options you need to use, so you can use the N delimeter to get the password read fully

EXEC master..sqlbackup N'-sql "BACKUP DATABASE ... WITH PASSWORD = [abcÇ]"'

But you might need more options than this depending on your situation.