error restoring sqb: "Failed to create the data link for fil

softbrandssoftbrands Posts: 2
edited February 24, 2011 10:08AM in SQL Virtual Restore 2
i am getting this error after selecting backup file and entering security password. anyone have an idea to get pass this.

09:07:47.451|Info |Logging |1 |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error
09:07:47.708|Info |ngWrapper.LogManager|1 |#1:Loaded assembly System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 from file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll/2.0.50727.4016 (NetFxQFE.050727-4000)
09:07:48.854|Info |ngWrapper.LogManager|1 |#1:Loaded assembly Accessibility, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a from file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll/2.0.50727.4016 (NetFxQFE.050727-4000)
09:07:54.928|Info |ngWrapper.LogManager|1 |#1:Loaded assembly Ninject.Core, Version=1.0.0.82, Culture=neutral, PublicKeyToken=c7192dc5380945e7 from file:///C:/Program Files/Red Gate/HyperBac/gui/Ninject.Core.DLL/1.0.0.82
09:07:55.018|Debug |EngineInternalModule|1 |#1:Declaring binding for service PersistenceSettings
09:07:55.027|Debug |EngineInternalModule|1 |#1:Declaring binding for service BackgroundErrorReporter
09:07:55.029|Debug |EngineInternalModule|1 |#1:Declaring binding for service StoppableTracker
09:07:55.048|Debug |ndardBindingSelector|1 |#1:Resolving binding for active request for BackgroundErrorReporter
09:07:55.050|Debug |ndardBindingSelector|1 |#1:1 candidate binding available for service BackgroundErrorReporter
09:07:55.051|Debug |ndardBindingSelector|1 |#1:One default binding and 0 conditional bindings match the current context
09:07:55.051|Debug |ndardBindingSelector|1 |#1:No conditional bindings matched, falling back on default binding.
09:07:55.055|Debug |ning.StandardPlanner|1 |#1:Activation plan for type BackgroundErrorReporter requested by default self-binding of BackgroundErrorReporter (via OrderedParameterProvider)
09:07:55.055|Debug |ning.StandardPlanner|1 |#1:Type has not been analyzed, building activation plan
09:07:55.082|Debug |ning.StandardPlanner|1 |#1:Activation plan for BackgroundErrorReporter built successfully
09:07:55.118|Debug |king.StandardTracker|1 |#1:Starting to track instance resulting from active request for BackgroundErrorReporter
using default self-binding of BackgroundErrorReporter (via OrderedParameterProvider)
09:07:55.142|Info |ngWrapper.LogManager|4 |#4:Loaded assembly RedGate.Shared.SQL, Version=8.1.0.4, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 from file:///C:/Program Files/Red Gate/HyperBac/gui/RedGate.Shared.SQL.DLL/8.1.0.4
09:07:55.236|Info |ngWrapper.LogManager|4 |#4:Loaded assembly System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 from file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll/2.0.50727.4016 (NetFxQFE.050727-4000)
09:07:55.245|Info |ngWrapper.LogManager|4 |#4:Loaded assembly System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a from file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll/2.0.50727.4016 (NetFxQFE.050727-4000)
09:07:55.300|Debug |SelectBackupPage |1 |ApplyContext - m_GetServerInformation: False
09:07:55.300|Debug |SelectBackupPage |1 |ApplyContext - m_DataPath: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data
09:07:55.300|Debug |SelectBackupPage |1 |ApplyContext - m_Databases: System.Collections.Generic.List`1[RedGate.SQLVirtualRestore.Engine.VirtualRestoreWizard.DbObjectName]
09:08:07.742|Error |Problem validating b|4 |System.Data.SqlClient.SqlException: Failed to create the data link for file 'C:\Temp\BackupDBs\epitome_penta\FULL_(local)_CORE_20110111_060001.sqb'. Win32 error code: 5.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.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)

Comments

  • Eddie DEddie D Posts: 1,803 Rose Gold 5
    Hi

    Sorry for the delay in replying to this forum post.

    Have I assumed correctly that this error is occurring when using the SQL Virtaul Restore Wizard?

    What version of the wizard are you using?

    What version of SQL Server are you restoring to?

    SQL Virtual Restore V2.3 is now available, can you please download using this LINK. Extract out the HyperBac Installers and select the correct installer for your system.

    Do you still experience the reported error using this new version of SQL Virtual Restore?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.