problem using SVR with encrypted backup file

SQL Virtual Restore: Rapidly mount live, fully functional databases direct from backups

Moderators: eddie davis, Colin Millerchip, fionag

problem using SVR with encrypted backup file

Postby kconner » Wed Dec 01, 2010 8:30 pm

I need to ask for some help with this one ...

I recently upgraded to SQL Backup Pro v 6.4.0.56 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.

Thank you,
Kerry[/img]
kconner
 
Posts: 4
Joined: Wed Nov 24, 2010 11:10 pm

Postby JonathanWatts » Thu Dec 02, 2010 11:21 am

Hi Kerry,

Sorry you are having issues with SQL Virtual Restore 2.2.0 - Can I ask which version of Windows you are running on and are you launching the Wizard from within one of the Microsoft tools like SSMS or from the start menu? If you are launching from within another tool could you try to launch it from the start menu (All Programs \\ Red Gate \\ HyperBac \\ SQL Virtual Restore Wizard) and see if this gives you the same error?

Thanks,

Jonathan
Jonathan Watts

-Project Manager
-Red Gate Software Ltd
JonathanWatts
 
Posts: 401
Joined: Wed Dec 15, 2004 11:05 am
Location: Red Gate Software

Postby kconner » Thu Dec 02, 2010 2:38 pm

Thanks for the response - the product is currently installed on a machine running Windows Server 2003 Standard SP2 (current with updates). I have been launching SVR from the Start menu for all of my testing. I do not have SSMS installed - I am still running Enterprise Manager.

Let me know what other information you might need.

Thanks,
Kerry
kconner
 
Posts: 4
Joined: Wed Nov 24, 2010 11:10 pm

Postby eddie davis » Fri Dec 03, 2010 12:54 pm

Thank you for your reply.

To investigate this problem further, I need to create a Support Ticket for you. Can you please take a screen shot of the error and send to support@red-gate.com. Also include your conatct details which will make logging the call easy for us to handle.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby eddie davis » Mon Dec 06, 2010 12:41 pm

Hi Kerry

Received your e-mail containing the requested information. Your call reference number is F0042052. I will contact you outside of this forum, whilst we continue to investigate the problem.

For other users following this forum post. I will post an update, when I have further information on the cause and solution to the problem.

If there are other users experiencing this issue, please contact the Red Gate Product Support Team.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 0 guests