Restore from older version issue

• 
  Could you please let us know the exact version and edition of SQL Backup 3 that's used?
  
  Thanks.

  petey September 16, 2009 12:04

  - 0 +
• 
  It looks like 3.2 Standard

  kermi September 16, 2009 12:14

  - 0 +
• 
  Thanks, it's definitely a bug. I'll post a patch tomorrow. Sorry about that.

  petey September 16, 2009 12:42

  - 0 +
• 
  You can download patch 6.2.0.1002 from here:
  
  ftp://ftp.red-gate.com/patches/SQL_Back ... 0_1002.zip
  
  You would need to stop the SQL Backup Agent service prior to replacing the existing copy (I would suggest renaming it in case you need it next time), after ensuring that no backups/restores are currently running.
  
  Thanks.

  petey September 17, 2009 01:13

  - 0 +
• 
  Is this the correct path? I'm getting 550 Folder /patches/SQL_Backup/SQB_6_2_0_1002.zip not found
  
  I did have another ftp site given to me previously that is ftp://support.red-gate.com/Patches/SQL_Backup/ and I did find a SQB_6_2_0_1002.zip file dated 9/17. I guessed that was the one but I'm still getting the same error.

  kermi September 17, 2009 08:38

  - 0 +
• 
  One other observation. We started recommending that our users use the Pro version. This has a higher encryption - 256. When creating backups the user can choose between 128 or 256. Using the command line the "KEYSIZE" variable needs to be used. This is not recognized by the 3.2 Standard edition since you could not choose the encryption level. I think that might be where the problem might be.

  kermi September 17, 2009 08:45

  - 0 +
• 
  Sorry about that, it should indeed have been ftp://support.red-gate.com/Patches/SQL_ ... 0_1002.zip.
  
  IIRC, SQL Backup 3 only offerred 1 level of encryption, which was 256-bit, and there was only 1 edition. There were no other encryption levels offered, hence no support for the KEYSIZE option.
  
  Starting with version 4, there were 2 levels of encryption, 128-bit and 256-bit. The Lite ediion didn't allow encryption at all, Standard allowed 128-bit and Pro allowed 128-bit and 256-bits.
  
  I've tested 6.2.0.1002 to restore an encrypted backup file created using 3.2, and it works fine. Could you send me the first 1024 bytes of the backup file in question? You can use the 'Extract file header' function in the SQL Backup test utility,which you can download from here:
  
  ftp://support.red-gate.com/Patches/SQL_Backup/SBaTU.zip
  
  Thanks.

  petey September 17, 2009 10:03

  - 0 +
• 
  When I try to use that utility I get a popup window that has the same error - Rijndael: Invalid key size - 0
  
  I tested on files that we are able to process using ver 6.0 and the utility works fine.
  
  We are able to process these files using SQL Backup 5.4 without any problems, so I know that there is nothing wrong with those files. I just don't want to downgrade the software on this particular machine. I've restarted the SQL Backup service to see if that would help but it does not.

  kermi September 17, 2009 10:25

  - 0 +
• 
  In that utility, select the 'Extract file header' from the 'Tools' menu item. Fill in the file names, and enter 1024 bytes to extract. Send the resulting file to me.
  
  Thanks.

  petey September 17, 2009 10:36

  - 0 +
• 
  I emailed the files to you.

  kermi September 17, 2009 11:31

  - 0 +
• 
  Thanks, I received the files. I also requested for an additional piece of information from you.
  
  Thanks.

  petey September 17, 2009 11:38

  - 0 +
• 
  What else do you need? I thought you needed the header information only

  kermi September 17, 2009 11:47

  - 0 +
• 
  Please try the updated patch from here:
  
  ftp://support.red-gate.com/Patches/SQL_ ... 0_1002.zip
  
  Thanks.

  petey September 18, 2009 03:43

  - 0 +
• 
  That did the trick... Thanks

  kermi September 18, 2009 08:26

  - 0 +
• 
  I ran into this problem back in September. I upgraded to version 6.3 and it appears that it cannot restore old SQL Backup files again. The patch I received for 6.2 worked, but seems like it was not included in version 6.3

  kermi February 10, 2010 11:46

  - 0 +
• 
  This is the original link to the old post
  
  http://www.red-gate.com/MessageBoard/vi ... 4766#34766

  kermi February 10, 2010 11:48

  - 0 +
• 
  I could not reproduce the error. I backed up a database using SQL Backup 3.2 with encryption and compression level 3, and successfully restored the database using SQL Backup 6.3.0.48.
  
  Could you please send me a sample back up file that was created using 3.2, but cannot be restored using 6.3?
  
  Thanks.

  petey February 16, 2010 09:50

  - 0 +

Add comment

Please sign in to leave a comment.