Password Limitations

rkoros

Are there any limitations regarding the characters used or the length of the password? I am trying to create an encrypted backup but the password that I want to use contains various characters, nothing fancy just some numbers, different case, etc. I can create the backup using them, but I cannot seem to decrypt it. If I use something like "Testing", it works fine, but anything more complex fails. Suggestions?

rkoros

There are limitations, SQL Backup will only handle passwords that are less than 17 characters in length. I have not found any characters that are restricted, but like I said earlier, nothing that fancy just basic keyboard characters used.

What is the possibility that a future release will allow for longer passwords to be used?

petey

There is a GUI bug with regards to the password entry edit boxes. It was limited to 16 characters. There is no visual/audio indication that this limit has been reached, so you might have thought that SQL Backup was still accepting additional characters.

To restore the encrypted backups made using the GUI, use the first 16 characters of the password that you entered.

This bug will be fixed in a future version.

There is no limit to the password length if you use the extended stored procedure or command line interface. Unfortunately, only the GUI allows you to generate encrypted passwords.