Cannot restore backup because I used square bracket in encryption password

rackl001rackl001 Posts: 2 New member
edited December 8, 2017 10:45AM in SQL Backup Previous Versions
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.
Tagged:

Best Answer

  • rackl001rackl001 Posts: 2 New member
    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.

Answers

  • 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.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.