What are the challenges you face when working across database platforms? Take the survey

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

Best Answer

  • Options
    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.


  • Options
    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.