Error restoring : The file failed to initialize correctly.

ProtoProto Posts: 13 Bronze 2
edited April 25, 2014 9:49AM in SQL Virtual Restore 2
We have a giant DB (1TB, 138GB compressed). I've used virtual restore before to quickly pull some data from our backups, but when I tried doing so this past week it failed. Here is the error log from SQL Server:
Starting up database 'DBNAME_Virtual'.
Error: 3283, Severity: 16, State: 1.
The file "DBNAME_2" failed to initialize correctly. Examine the error logs for more details.
Error: 3283, Severity: 16, State: 1.
The file "DBNAME_1_log" failed to initialize correctly. Examine the error logs for more details.
Error: 3283, Severity: 16, State: 1.
The file "DBNAME_2_log" failed to initialize correctly. Examine the error logs for more details.

Here is the HyperBac log:
*******************************************************************
*
* 15 Apr 14 12:27:11.212 OPENED LOG FILE
*
HyperFile=000000001CB3DBA0
FileName=E:\SQL Server\DBNAME_1_DBNAME_Virtual.vmdf
OpenTime=Tue Apr 15 12:27:01 2014
OpenProcessId=8552
OpenProcessName=\Device\HarddiskVolume1\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Binn\sqlservr.exe
ProcessAttr1=0
ProcessAttr2=0
IndexNumber=0x2CE0000000006F7
HeaderVersion=2
FileType=1
FormatVersion=0x3
CreateVersion=0x5010D00
CreateOS=0x10600
FileFlags=0xB8
RequiredVersion=0x3
WriteAccess=Yes
FillFactor=118272
VirtualEOF=0x1863E00000
FileActualStart=0x400
FileActualEnd=0x20000
LastDataBlock=0x0
FileActualMetaEnd=0x0
LastCrcOffset=0x1863E00000
SequentialOffset=0x1863E00000
LastBlockOffset=0x1863E00000
IndexType4Format=1
IndexStart=0x20000
IndexEnd=0x0
OpenHandleCount=1
FileDirty=No
IoError=0
UpdateCount=0x3
LastIoOffset=0x0
ActiveWrites=0
FileState=0x1
LastSumOffset=0x0
AffinityMask=0xFFFFFFFFFFFFFFFF
*
*******************************************************************

15 Apr 14 12:27:11.212 HyperOpenMtfDataFile: FileRecord: 000000001CB3DBA0, Failed to open data file: \Backup\FULL_(local)_DBNAME_20140411_000001_20.sqb. Error: 0x3.
15 Apr 14 12:27:11.215 GetRedirectedMTF: FileRecord: 000000001CB3DBA0, Failed to open data file. Error: 0x3.
15 Apr 14 12:27:11.215 HyperProcessBlockJob: Failed to load cache data, File offset: 0x10000. Error: 3.
15 Apr 14 12:27:11.215 HyperVirtualRead: Failed to read block at offset: 0x12000, Length: 0x2000. Error: 3
15 Apr 14 12:27:11.216 HyperOpenMtfDataFile: FileRecord: 000000001CB3DBA0, Failed to open data file: \Backup\FULL_(local)_DBNAME_20140411_000001_20.sqb. Error: 0x3.
15 Apr 14 12:27:11.216 GetRedirectedMTF: FileRecord: 000000001CB3DBA0, Failed to open data file. Error: 0x3.
15 Apr 14 12:27:11.217 HyperProcessBlockJob: Failed to load cache data, File offset: 0x10000. Error: 3.
15 Apr 14 12:27:11.217 HyperVirtualRead: Failed to read block at offset: 0x12000, Length: 0x2000. Error: 3
15 Apr 14 12:27:11.467 HyperOpenMtfDataFile: FileRecord: 000000001CB3DBA0, Failed to open data file: \Backup\FULL_(local)_DBNAME_20140411_000001_20.sqb. Error: 0x3.
15 Apr 14 12:27:11.467 GetRedirectedMTF: FileRecord: 000000001CB3DBA0, Failed to open data file. Error: 0x3.
15 Apr 14 12:27:11.468 HyperProcessBlockJob: Failed to load cache data, File offset: 0x10000. Error: 3.
15 Apr 14 12:27:11.468 HyperVirtualRead: Failed to read block at offset: 0x12000, Length: 0x2000. Error: 3
15 Apr 14 12:27:11.971 HyperOpenMtfDataFile: FileRecord: 000000001CB3DBA0, Failed to open data file: \Backup\FULL_(local)_DBNAME_20140411_000001_20.sqb. Error: 0x3.
15 Apr 14 12:27:11.972 GetRedirectedMTF: FileRecord: 000000001CB3DBA0, Failed to open data file. Error: 0x3.
15 Apr 14 12:27:11.972 HyperProcessBlockJob: Failed to load cache data, File offset: 0x10000. Error: 3.
15 Apr 14 12:27:11.972 HyperVirtualRead: Failed to read block at offset: 0x12000, Length: 0x2000. Error: 3
15 Apr 14 12:27:12.725 HyperOpenMtfDataFile: FileRecord: 000000001CB3DBA0, Failed to open data file: \Backup\FULL_(local)_DBNAME_20140411_000001_20.sqb. Error: 0x3.
15 Apr 14 12:27:12.726 GetRedirectedMTF: FileRecord: 000000001CB3DBA0, Failed to open data file. Error: 0x3.
15 Apr 14 12:27:12.726 HyperProcessBlockJob: Failed to load cache data, File offset: 0x10000. Error: 3.
15 Apr 14 12:27:12.726 HyperVirtualRead: Failed to read block at offset: 0x12000, Length: 0x2000. Error: 3
15 Apr 14 12:27:12.727 HyperOpenMtfDataFile: FileRecord: 000000001CB3DBA0, Failed to open data file: \Backup\FULL_(local)_DBNAME_20140411_000001_20.sqb. Error: 0x3.
15 Apr 14 12:27:12.728 GetRedirectedMTF: FileRecord: 000000001CB3DBA0, Failed to open data file. Error: 0x3.
15 Apr 14 12:27:12.728 HyperProcessBlockJob: Failed to load cache data, File offset: 0x10000. Error: 3.
15 Apr 14 12:27:12.729 HyperVirtualRead: Failed to read block at offset: 0x12000, Length: 0x2000. Error: 3
15 Apr 14 12:27:12.978 HyperOpenMtfDataFile: FileRecord: 000000001CB3DBA0, Failed to open data file: \Backup\FULL_(local)_DBNAME_20140411_000001_20.sqb. Error: 0x3.
15 Apr 14 12:27:12.979 GetRedirectedMTF: FileRecord: 000000001CB3DBA0, Failed to open data file. Error: 0x3.
15 Apr 14 12:27:12.979 HyperProcessBlockJob: Failed to load cache data, File offset: 0x10000. Error: 3.
15 Apr 14 12:27:12.980 HyperVirtualRead: Failed to read block at offset: 0x12000, Length: 0x2000. Error: 3
15 Apr 14 12:27:13.479 HyperOpenMtfDataFile: FileRecord: 000000001CB3DBA0, Failed to open data file: \Backup\FULL_(local)_DBNAME_20140411_000001_20.sqb. Error: 0x3.
15 Apr 14 12:27:13.479 GetRedirectedMTF: FileRecord: 000000001CB3DBA0, Failed to open data file. Error: 0x3.
15 Apr 14 12:27:13.480 HyperProcessBlockJob: Failed to load cache data, File offset: 0x10000. Error: 3.
15 Apr 14 12:27:13.480 HyperVirtualRead: Failed to read block at offset: 0x12000, Length: 0x2000. Error: 3
15 Apr 14 12:27:14.229 HyperOpenMtfDataFile: FileRecord: 000000001CB3DBA0, Failed to open data file: \Backup\FULL_(local)_DBNAME_20140411_000001_20.sqb. Error: 0x3.
15 Apr 14 12:27:14.230 GetRedirectedMTF: FileRecord: 000000001CB3DBA0, Failed to open data file. Error: 0x3.
15 Apr 14 12:27:14.230 HyperProcessBlockJob: Failed to load cache data, File offset: 0x10000. Error: 3.
15 Apr 14 12:27:14.230 HyperVirtualRead: Failed to read block at offset: 0x12000, Length: 0x2000. Error: 3
15 Apr 14 12:48:37.329 HyperFlushBuffers: Previous async error: 3.
15 Apr 14 12:48:37.329 HyperProcessOperation: Failed to flush buffers: 3.

I've tried on the backups from the previous two weeks and always get the same error. Backups are multi-file (20).

Any idea what is happening here? I've used this tool before with no issues.

oh, and it's Virtual Restore version 2.2

Comments

  • ProtoProto Posts: 13 Bronze 2
    another note, restoring the backups as normal works just fine. so the backup files themselves are good.
  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    Thank you for your forum post and sorry that you have encountered problem.

    A support call has been created for you HERE.

    Can you please send an email to support@red-gate.com (quoting call reference #18321) or update the call directly via the link and attach a copy of the HyperBac service.log file located in the %system root%\Red Gate\Hyperbac\logs folder?

    It appears from the information you have provided, SQL Virtual Restore has failed to open the 20th backup file - FULL_(local)_DBNAME_20140411_000001_20.sqb

    What version of SQL Backup created the sqb file or files you are using to mount the virtual database?

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