Red Gate forums :: View topic - Error when selecting backup file to restore
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Virtual Restore 2
SQL Virtual Restore 2 forum

Error when selecting backup file to restore

Search in SQL Virtual Restore 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Jason Hannas



Joined: 15 Dec 2006
Posts: 23
Location: Aberdeen, MD USA

PostPosted: Wed Nov 17, 2010 4:42 pm    Post subject: Error when selecting backup file to restore Reply with quote

I downloaded and installed SQL Virtual Restore 2 last Friday afternoon. Everything installed without any issues, however I cannot get past step 2 on the wizard. Selecting a file to restore prompts me to enter my password (it is an encrypted SQB v.6 backup file), it accepts my password and then throws an error: Failed to find the service working directory. Check the 'InstallDir' registry key. Win 32 error:5



I haven't found anything useful on the forums regarding this error. As you can see, the registry key I believe is referenced in the error does exist and has the correct path.



The service is running--there are no issues.



Any ideas? I'd sure like to get this going so I can at least test a few restores prior to my evaluation expiring. Thanks!
Jason
Back to top
View user's profile Send private message
JonathanWatts



Joined: 15 Dec 2004
Posts: 401
Location: Red Gate Software

PostPosted: Wed Nov 17, 2010 6:26 pm    Post subject: Reply with quote

Hi there,

I think we need to get a log to discover what is going on:
10) Start the SQL Virtual Restore Wizard.
20) Click on the icon next to the text "SQL Virtual Restore Wizard" in the application's title bar, you should see a menu called "Minimum Log Levels : (No Logging)".
30) From here you can change the logging level. Set it to Verbose.
40) Recreate the error
50) Once it has occurred, return to the application icon menu and select the Open Current Log File option.
60) If you could then email the contents of this file to jonathan [dot] watts [at] red-gate [dot] com that would be great. We will take a look at the file and get back to you.

BTW If your trial does expire, let us know and we can extend it for you.
_________________
Jonathan Watts

-Project Manager
-Red Gate Software Ltd
Back to top
View user's profile Send private message
Jason Hannas



Joined: 15 Dec 2006
Posts: 23
Location: Aberdeen, MD USA

PostPosted: Wed Nov 17, 2010 10:12 pm    Post subject: Reply with quote

Sure thing, Jonathan. Email with log file is on its way.
Back to top
View user's profile Send private message
Koen Mevissen



Joined: 26 Jan 2011
Posts: 4

PostPosted: Wed Jan 26, 2011 9:01 pm    Post subject: Reply with quote

Any news on this issue? I'm having the exact same error message. I'm on a licensed version.

Virtual Restore has been working fine for a few weeks, but it's failing now.

Here's some Virtual Restore logging showing the crash: (will also ticket this at customer support to make sure it's being picked up Smile)

20:59:25.195|Info |Logging |1 |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error
20:59:25.476|Info |ngWrapper.LogManager|1 |#1:Loaded assembly System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 from file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll/2.0.50727.4927 (NetFXspW7.050727-4900)
20:59:35.228|Info |ngWrapper.LogManager|1 |#1:Loaded assembly Ninject.Core, Version=1.0.0.82, Culture=neutral, PublicKeyToken=c7192dc5380945e7 from file:///C:/Program Files (x86)/Red Gate/HyperBac/gui/Ninject.Core.DLL/1.0.0.82
20:59:35.328|Debug |EngineInternalModule|1 |#1:Declaring binding for service PersistenceSettings
20:59:35.337|Debug |EngineInternalModule|1 |#1:Declaring binding for service BackgroundErrorReporter
20:59:35.339|Debug |EngineInternalModule|1 |#1:Declaring binding for service StoppableTracker
20:59:35.365|Debug |ndardBindingSelector|1 |#1:Resolving binding for active request for BackgroundErrorReporter
20:59:35.366|Debug |ndardBindingSelector|1 |#1:1 candidate binding available for service BackgroundErrorReporter
20:59:35.369|Debug |ndardBindingSelector|1 |#1:One default binding and 0 conditional bindings match the current context
20:59:35.369|Debug |ndardBindingSelector|1 |#1:No conditional bindings matched, falling back on default binding.
20:59:35.377|Debug |ning.StandardPlanner|1 |#1:Activation plan for type BackgroundErrorReporter requested by default self-binding of BackgroundErrorReporter (via OrderedParameterProvider)
20:59:35.377|Debug |ning.StandardPlanner|1 |#1:Type has not been analyzed, building activation plan
20:59:35.404|Debug |ning.StandardPlanner|1 |#1:Activation plan for BackgroundErrorReporter built successfully
20:59:35.448|Debug |king.StandardTracker|1 |#1:Starting to track instance resulting from active request for BackgroundErrorReporter
using default self-binding of BackgroundErrorReporter (via OrderedParameterProvider)
20:59:35.463|Info |ngWrapper.LogManager|4 |#4:Loaded assembly RedGate.Shared.SQL, Version=8.1.0.4, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 from file:///C:/Program Files (x86)/Red Gate/HyperBac/gui/RedGate.Shared.SQL.DLL/8.1.0.4
20:59:35.504|Info |ngWrapper.LogManager|4 |#4:Loaded assembly System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 from file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll/2.0.50727.4927 (NetFXspW7.050727-4900)
20:59:35.514|Info |ngWrapper.LogManager|4 |#4:Loaded assembly System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a from file:///C:/Windows/assembly/GAC_64/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll/2.0.50727.4927 (NetFXspW7.050727-4900)
20:59:35.555|Debug |SelectBackupPage |1 |ApplyContext - m_GetServerInformation: False
20:59:35.555|Debug |SelectBackupPage |1 |ApplyContext - m_DataPath: C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data
20:59:35.555|Debug |SelectBackupPage |1 |ApplyContext - m_Databases: System.Collections.Generic.List`1[RedGate.SQLVirtualRestore.Engine.VirtualRestoreWizard.DbObjectName]
20:59:41.588|Error |Problem validating b|4 |System.Data.SqlClient.SqlException: Failed to find the service working directory. Check the 'InstallDir' registry key. Win32 error: 5
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at RedGate.SQLVirtualRestore.Engine.ExtendedProc.#t.#z2.#YKW()
at RedGate.SQLVirtualRestore.Engine.ExtendedProc.#TnW(String context, Action cmd)
at RedGate.SQLVirtualRestore.Engine.ExtendedProc.#bag(String query)
at RedGate.SQLVirtualRestore.Engine.ExtendedProc.Call(String argSpec, String[] args)
at #kbW.#ssQ.DecryptHeader(SqlBackupHeader& header)
at #kbW.#ssQ.GetHeaderInformation()
at RedGate.SQLVirtualRestore.Engine.VirtualRestoreWizard.GenericSqlServerFileReader.ConstructInstance(Builder builder, String file)
Back to top
View user's profile Send private message
Jason Hannas



Joined: 15 Dec 2006
Posts: 23
Location: Aberdeen, MD USA

PostPosted: Thu Jan 27, 2011 12:01 am    Post subject: Reply with quote

For this particular issue, if you navigate to that registry key and edit permissions to allow your SQL Service Account full control on that key, you should be able to get past it and load the file.
Back to top
View user's profile Send private message
Koen Mevissen



Joined: 26 Jan 2011
Posts: 4

PostPosted: Thu Jan 27, 2011 8:19 am    Post subject: Reply with quote

This worked perfectly, many thanks Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group