Red Gate forums :: View topic - Restore Error
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

Restore Error

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



Joined: 16 May 2007
Posts: 50

PostPosted: Fri Aug 20, 2010 12:15 pm    Post subject: Restore Error Reply with quote

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:

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

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


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

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

Quote:
*****************************************************************
*
* 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
Back to top
View user's profile Send private message
RML51



Joined: 31 Oct 2005
Posts: 16

PostPosted: Thu Aug 26, 2010 5:09 pm    Post subject: Using SQL Virtual Restore with multiple .SQB files Reply with quote

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