Restore Error

howarthcd

I'm running the trial edition of SQL Virtual Restore 2.0, and having an issue restoring a backup of a particular database.

The database was backed-up using SQL Backup 6.4.0.56, to two files (14GB each) and with compression level 1. The source database is attached to an instance of SQL Server 2005, the target instance is SQL Server 2008 R2.


The following command restores the database successfully:

EXEC master..sqlbackup '
-sql			

"RESTORE DATABASE [TestDB] 
FROM 
    DISK = ''D:\Temp\TestDB_20100820042616_FULL_02.sqb'', 
    DISK = ''D:\Temp\TestDB_20100820042616_FULL_01.sqb'' 
WITH 
    MOVE ''TestDB1Data'' 
        TO ''E:\MSSQL10_50.SQL2008R2\MSSQL\Data\TestDB_data_1_TestDB.mdf'',
    MOVE ''TestDBlog1''
        TO ''D:\MSSQL10_50.SQL2008R2\MSSQL\Data\TestDB_log_1_TestDB.ldf'',
NORECOVERY, REPLACE"'
GO

...the following command fails straightaway with the error included below:

RESTORE DATABASE [TestDB] 
FROM 
    DISK = 'D:\Temp\TestDB_20100820042616_FULL_02.sqb', 
    DISK = 'D:\Temp\TestDB_20100820042616_FULL_01.sqb' 
WITH 
    MOVE 'TestDB1Data' 
        TO 'E:\MSSQL10_50.SQL2008R2\MSSQL\Data\TestDB_data_1_TestDB.vmdf',
    MOVE 'TestDBlog1'
        TO 'D:\MSSQL10_50.SQL2008R2\MSSQL\Data\TestDB_log_1_TestDB.vldf',
NORECOVERY, REPLACE
GO

Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 3634, Level 16, State 1, Line 1
The operating system returned the error '32(failed to retrieve text for this error. Reason: 1815)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'E:\MSSQL10_50.SQL2008R2\MSSQL\Data\TestDB_data_1_TestDB.vmdf'.
Msg 3156, Level 16, State 8, Line 1
File 'TestDB1Data' cannot be restored to 'E:\MSSQL10_50.SQL2008R2\MSSQL\Data\TestDB_data_1_TestDB.vmdf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

An error is also returned in the SQL Virtual Restore GUI when the backup files have been selected:

Error occurred when scanning backup files
Data is Null. This method or property cannot be called on Null values.

Here's an extract from the Hyperbac log file:

*****************************************************************
*
* 20 Aug 10 12:01:52.484 OPENED LOG FILE
*
HyperFile=08DDC0A8
FileName=E:\MSSQL10_50.SQL2008R2\MSSQL\Data\TestDB_data_1_TestDB.vmdf
OpenTime=Fri Aug 20 12:01:52 2010
OpenProcessId=1616
OpenProcessName=\Device\HarddiskVolume3\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\Binn\sqlservr.exe
ProcessAttr1=0
ProcessAttr2=0
IndexNumber=0x8000000000057
HeaderVersion=2
*
*******************************************************************

20 Aug 10 12:01:52.484 GetAndLoadIndexMap: Failed to get the index map for offset: 0x0.
20 Aug 10 12:01:52.562 GetRwIndexElement: FileRecord: 08DDC0A8, Failed get and load index map for offset: 0x0, Error: 0xFFFFFFFF.
20 Aug 10 12:01:52.593 LoadCompData: Error getting index element: 0xFFFFFFFF
20 Aug 10 12:01:52.593 HyperProcessBlockJob: Failed to load comp data, File offset: 0x0. Error: -1.
20 Aug 10 12:01:52.593 HyperVirtualWrite: Failed to write block to offset: 0x0, Length: 0x2000, Offset: 0x0. Error: -1
20 Aug 10 12:01:52.593 HyperFlushBuffers: Previous async error: -1.
20 Aug 10 12:01:52.593 HyperProcessOperation: Failed to flush buffers: -1.
20 Aug 10 12:01:52.593 HyperCloseFile: Previous async error: -1.

*******************************************************************
*
* 20 Aug 10 12:01:52.624 OPENED LOG FILE
*
HyperFile=08DDC0A8
FileName=E:\MSSQL10_50.SQL2008R2\MSSQL\Data\TestDB_data_1_TestDB.vmdf
OpenTime=Fri Aug 20 12:01:52 2010
OpenProcessId=1616
OpenProcessName=\Device\HarddiskVolume3\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\Binn\sqlservr.exe
ProcessAttr1=0
ProcessAttr2=0
IndexNumber=0x8000000000057
HeaderVersion=2
*
*******************************************************************

20 Aug 10 12:01:52.624 The file: E:\MSSQL10_50.SQL2008R2\MSSQL\Data\TestDB_data_1_TestDB.vmdf (FileRecord: 08DDC0A8) was not shut down cleanly. Rebuilding now...
20 Aug 10 12:01:52.624 HyperLoadFileInfo: Error rebuilding the FileRecord: 08DDC0A8. Error: 0x20.
20 Aug 10 12:01:52.624 HyperInitialize: Failed to load file info (32).

I can successfully 'virtually-restore' a much smaller second database backed-up from the same source server using the same backup settings as the larger database.

Any ideas as to what might be wrong?

Thanks
Chris

RML51

I, too, am interested to see if SQL Virtual Restore will work with a database backup set that consists of multiple .sqb files. We use multiple .sqb files to improve backup runtimes. We will need multiple .sqb file restore capability from SQL Virtual Restore.