Restore encypted SQB issue

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

Moderators: eddie davis, Colin Millerchip, fionag

Restore encypted SQB issue

Postby reulberg » Fri Feb 03, 2012 5:12 pm

I seem to be having a strange issue restoring an encrypted .sqb file
I have 2 instances.
the restore on instance 1 of an encrypted sqb worked fine.
attempting to restore a different encrypted sqb on instance 2 gave me this error:
Failed to encrypt information. Win32 error code: -2146893809.
reulberg
 
Posts: 9
Joined: Tue Aug 16, 2011 4:49 pm

Postby eddie davis » Mon Feb 06, 2012 12:53 pm

Thank you for your post into the forum.

I suspect that your issue maybe more related to SQL Backup than the SQL Virtual Restore.

Can you please run the following SQL Backup commands in a new query window to verify the encrypted backup file used against instance 2:
Code: Select all
USE master
GO
EXECUTE master..sqlbackup '-SQL "RESTORE FILELISTONLY FROM DISK = ''<path to sqb backup file>.sqb'' WITH PASSWORD ''your_password'', SINGLERESULTSET"'
GO

And

USE master
GO
EXECUTE master..sqlbackup '-SQL "RESTORE VERIFYONLY FROM DISK = ''<path to sqb backup file>.sqb'' WITH PASSWORD ''your_password''"'
GO
 


A support call from this forum post has been created for you, call reference F0057009. Please reply with the results of running the above query via e-mail to support@red-gate.com and place the call reference number F0057009 into the subject field of the e-mail.

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 Matthew Flatt » Mon Feb 06, 2012 12:58 pm

Hi reulberg,

I am sorry to hear that you are having this issue.

Are these 2 instances on the same machine or different machines?

Where is the Win32 error? Coming from SQL Server or a HyperBac log file?

Would you be able to paste me the output from SQL Server and the log file contents from Program Files (x86)\\Red Gate\\HyperBac\\Logs or send them to support@red-gate.com referencing this forum post.

Thanks,
Matthew Flatt
Test Engineer, HyperBac
Matthew Flatt
 
Posts: 253
Joined: Tue Jan 15, 2008 4:45 pm

Postby reulberg » Mon Feb 06, 2012 7:50 pm

Eddie: the server does not have SQL backup installed, the file decypts, converts and restores just fine via SQBconverter, and native restore.

I will script the SQL virtual restore actions and post the output momentarily -- I was using the sql virtual restore Gui when I encountered this error.

Matthew: 2 instances of sql server on the same physical box. I am not sure of the origin, I will run the script version of the sql virtual restore commands, and email the results as requested.

Thanks![/b]
reulberg
 
Posts: 9
Joined: Tue Aug 16, 2011 4:49 pm

Postby reulberg » Mon Feb 06, 2012 8:51 pm

Interesting...

When I first encountered this error I was using the gui, and the gui doesn't allow one to proceed past file selection.

When manually executing a script, it throws the same error, but completes with a usable DB...

Requested info emailed.
reulberg
 
Posts: 9
Joined: Tue Aug 16, 2011 4:49 pm

Postby reulberg » Fri Feb 17, 2012 7:30 am

so when can I expect follow -up on this?

due to the error, I cannot automate this restore job.
reulberg
 
Posts: 9
Joined: Tue Aug 16, 2011 4:49 pm

Postby eddie davis » Fri Feb 17, 2012 12:31 pm

I am sorry for the delay in replying back to you.

Two SQL Instances on the same server. Using SQL Virtual Restore (SVR) wizard against one instance you can successfully an encrypted SQL Backup .sqb file. However, using the same SQL Virtual Restore wizard on the second instance restoring a different encrypted .sqb file the process fails with the reported Win32 error code: -2146893809.

The server that creates the encrypted SQL Backup .sqb files, are they from the same server? Or from different servers?

What version of SQL Backup creates each .sqb file you are using with SVR?

What version of SVR and HyperBac components are installed?

The .sqb file that restores successfully on the first Instance, are you able to successfully restore this file using the SVR wizard to the second instance?

On the server where SVR is installed, can you please reply to support call F0057009 with the following Hyperbac files:

- Status.dat, openstatus.dat and hyperbac.conf from C:\\Program Files (x86)\\Red Gate\\HyperBac\\bin on 64-bit machine or C:\\Program Files\\Red Gate\\HyperBac\\bin on 32-bit machine
- Service.log and any other logs in C:\\Program Files (x86)\\Red Gate\\HyperBac\\logs on 64-machine or C:\\Program Files\\Red Gate\\HyperBac\\logs on 32-machine

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 reulberg » Fri Feb 17, 2012 4:31 pm

The server that creates the encrypted SQL Backup .sqb files, are they from the same server? Or from different servers?
The .sqb file is from the same server

What version of SQL Backup creates each .sqb file you are using with SVR?
6.5.1.9
What version of SVR and HyperBac components are installed?
hyperback: 5.5.1.10; SVR: 2.3
The .sqb file that restores successfully on the first Instance, are you able to successfully restore this file using the SVR wizard to the second instance?
No, it will not let me get past the file selection screen.

Requested files zipped and emailed.
reulberg
 
Posts: 9
Joined: Tue Aug 16, 2011 4:49 pm

Postby reulberg » Tue May 08, 2012 4:30 pm

It turns out to have been a permissions issue:
in the
[OS drive]:\\ProgramData\\Microsoft\\Crypto\\RSA\\MachineKeys
directory, the account that Hyperbak service was running under didn't have 'full control' permissions. Once that was addressed, smooth sailing.

Many thanks to Red Gate support for figuring it out!
reulberg
 
Posts: 9
Joined: Tue Aug 16, 2011 4:49 pm


Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 0 guests