I need to ask for some help with this one ...
I recently upgraded to SQL Backup Pro v 220.127.116.11 and purchased SQL Virtual Restore (I am now running v2.2). I am running these on SQL Server 2000 SP3.
I am currently testing the products before I deploy them to my production servers. I've so far been able to use Virtual Restore successfully on a native backup file and an unencrypted sqb. The feature set for v2.2 says that it will now work with encrypted backup files created with Backup Pro v6. I have so far been unable to get this to work. I believe that I have followed the instructions but I guess that I missed a step somewhere.
Here are the commands that I used to associate a password with the encrypted file I am working with:
exec sp_dropextendedproc 'xp_validate_sqb_backup'
exec dbo.sp_addextendedproc N'xp_validate_sqb_backup','C:\\Program Files\\Microsoft SQL Server\\MSSQL\\Binn\\xpHyperBac.dll';
exec master..xp_validate_sqb_backup @filename = 'f:\\_scratch\\scansystem\\FULL_(local)_encrypted_20101201_125340.sqb', @password = 'xxxxxxxx';
All of the lines ran without error - on the final line, I received the message 'Password check completed successfully.'
When I attempt to open the encrypted backup using the SVR wizard I get the following message at the bottom of the wizard step 2 screen:
Could not read registry: SOFTWARE\\Microsoft\\Microsoft SQL Server\\Instance Names\\SQL /MSSQLSERVER
REST: Is64BitMachine: False, Is64BitProcess: False, flag: 0
Sorry, was unable to paste an image into this.
I would appreciate any assistance that I could get with this. I don't know if it matters but the encrypted db was created using level 3 compression.