Can I restore encrypted backup created on different server?
If I have an encrypted .SQB file created on one server using Backup Pro 6.2, can I restore it to a different database server using a different install of Backup Pro 6.2 on the destination server?
This is what I am trying to do, but when I attempt to do this, I am unable to. It never enables the "Decrypt" input, but it also is not explicitly stating an error in the GUI.
Thanks,
Jason
This is what I am trying to do, but when I attempt to do this, I am unable to. It never enables the "Decrypt" input, but it also is not explicitly stating an error in the GUI.
Thanks,
Jason
Comments
I have encrypted .sqb backup file from production
restored it to the QA server via script (or GUI) today
RESTORE .............
WITH PASSWORD = 'xxxxxx'
I'm using SQL Backup 6.3 already though
DBA, MCITP
Could you please run a small test for us:
- back up a small database e.g. model
- copy the file to the other server
- run and send us the output from the following commands on the other server: where [...] is the fully qualified name of the copied file.
Thank you.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE AjayDB TO DISK = ''Z:\WrkFolder\AjayDB_201304011011_full.bak'' WITH COMPRESSION = 1, THREADCOUNT = 4, KEYSIZE = 256, PASSWORD = ''<ENCRYPTEDPASSWORD>abc12defLHG</ENCRYPTEDPASSWORD>''"'
Now, when I try to restore it via GUI, I supply the same password as above: abcd12defLHG. But it says: bad password. I tried to do it thru script as well, but did not help. I tried both of the following commands - none helped.
EXECUTE master.dbo.sqlbackup N'-SQL "RESTORE DATABASE [AjayDB] FROM DISK = ''Z:\WrkFolder\AjayDB_201304011011_full.bak'' WITH DISCONNECT_EXISTING, PASSWORD = ''abc12defLHG'', REPLACE, MOVE ''AjayDB'' TO ''Z:\WrkFolder\AjayDB.mdf'', MOVE ''AjayDB_log'' TO ''Z:\WrkFolder\AjayDB.ldf'', RECOVERY"'
EXECUTE master.dbo.sqlbackup N'-SQL "RESTORE DATABASE [AjayDB] FROM DISK = ''Z:\WrkFolder\AjayDB_201304011011_full.bak'' WITH DISCONNECT_EXISTING, PASSWORD = ''<ENCRYPTEDPASSWORD>abc12defLHG</ENCRYPTEDPASSWORD>'', REPLACE, MOVE ''AjayDB'' TO ''Z:\WrkFolder\AjayDB.mdf'', MOVE ''AjayDB_log'' TO ''Z:\WrkFolder\AjayDB.ldf'', RECOVERY"'
This is the msg generated:
SQL Backup v7.0.6.2
Restoring AjayDB (database) from:
Z:\WrkFolder\AjayDB_201304011011_full.bak
Error 710: Wrong password entered.
SQL Backup exit code: 710
(6 row(s) affected)
name value
exitcode 710
sqlerrorcode 0
filename001 Z:\WrkFolder\AjayDB_201304011011_full.bak
(3 row(s) affected)
Can you help?
Thanks.
Ajay
E.g. when you back up a database or set up a backup job using the GUI, it encrypts the password you entered so that anyone looking at the script will not know the plain-text password.
If SQL Backup allowed users to restore the database using the same encrypted value, it defeats the purpose of encrypting the password. Thus, you need to know the plain text password to restore the database.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8