How can we help you today? How can we help you today?

Cannot restore backup because I used square bracket in encryption password

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.
srackley
0

Comments

2 comments

Sort by
  • 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.
    Dan B
    0
  • 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.
    rackl001
    0

Add comment

Please sign in to leave a comment.