Error: Rijndael: Invalid key size - 0, red gate

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Error: Rijndael: Invalid key size - 0, red gate

Postby dklein9930 » Wed May 01, 2013 8:49 pm

Error when attempting a restore. Version: 6.4.0.56
dklein9930
 
Posts: 13
Joined: Wed Mar 02, 2011 3:27 pm

Postby petey » Thu May 02, 2013 9:38 am

Could you please try patch 6.5.2.23?

ftp://support.red-gate.com/patches/sql_ ... 5_2_23.zip

The zip file contains two files:

SQBCoreService.exe
SQLBackupC.exe

To apply the patch, please follow the steps below:

1. Close all GUI connections to the SQL Server.
2. Ensure that no SQL Backup jobs are in progress.
3. Stop the SQL Backup Agent Service, or disable the cluster resource if on a cluster.
4. On the SQL Server where the SQL Backup server components are installed, navigate to the installation directory. Defaults are:

32-bit Machines - C:\\Program Files\\Red Gate\\SQL Backup 6\\(local) or <SQL Instance Name>
64-bit Machines - C:\\Program Files (x86)\\Red Gate\\SQL Backup 6\\(local) or <SQL Instance Name>

5. In the folder you will find an existing SQBCoreService.exe and SQL BackupC.exe. Rename the existing files, for example to OLDSQBCoreService.exe and OLDSQLBackupC.exe.
6. Now copy in the files extracted from the downloaded zip.
7. Restart the SQL Backup agent service/cluster resource, and ensure that it starts successfully.
8. Perform a test backup to ensure that all is OK. Then test to see if the original error occurs.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2227
Joined: Sun Apr 24, 2005 12:34 pm

Postby dklein9930 » Thu May 02, 2013 8:43 pm

Thanks for the reply Peter. What is this error? We have been using this version for almost 3 years, we have clients who are receiving backups from us in this version. Management is reluctant to make changes. Why did this error happen all of the sudden?

Thanks again,
David
dklein9930
 
Posts: 13
Joined: Wed Mar 02, 2011 3:27 pm

Postby petey » Fri May 03, 2013 2:15 am

I can't remember the cause, as it's been almost 2 years since 6.5 was released. Was version 6.5 able to restore from your backup file?
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2227
Joined: Sun Apr 24, 2005 12:34 pm

New error

Postby dklein9930 » Mon May 06, 2013 2:46 pm

Hey Peter,

I switched out the files and the first transaction log backups came back with this error:


"Executed as user: dbo. SQL Backup failed with exit code: 667 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed."

Thanks,
David
dklein9930
 
Posts: 13
Joined: Wed Mar 02, 2011 3:27 pm

More details

Postby dklein9930 » Mon May 06, 2013 2:54 pm

Did this occur cause the transaction logs were on a different version than the full backups? Is the first action after the switch to take a full backup?

Thanks,
David
dklein9930
 
Posts: 13
Joined: Wed Mar 02, 2011 3:27 pm

I have not represented the problem properly

Postby dklein9930 » Mon May 06, 2013 5:59 pm

My apologies Peter,

The server that is taking the backup is running Redgate backup version 5.3.0.178. The server that we are attempting a ‘partial’ restore on is running version 6.4.0.56. How would this change the solution to our problem? What cost/work is involved in upgrading version 5 listed above to the version to sent me 6.5.2.23?

Thanks for your time,
David
dklein9930
 
Posts: 13
Joined: Wed Mar 02, 2011 3:27 pm

Postby petey » Wed May 08, 2013 4:22 am

Version 6.5.2.23 can restore backups created in 5.3.0.178. The error you are experiencing (667), indicates that the SQL Backup trial period has expired.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2227
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests