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

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

Moderators: eddie davis, Colin Millerchip, fionag

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

Postby softbrands » Mon Feb 14, 2011 6:16 pm

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)
softbrands
 
Posts: 1
Joined: Mon Feb 14, 2011 6:12 pm

Postby eddie davis » Thu Feb 24, 2011 4:08 pm

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
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