Red Gate forums :: View topic - Error on server Log
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

Error on server Log

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



Joined: 31 Dec 2008
Posts: 69

PostPosted: Tue Apr 05, 2011 5:03 pm    Post subject: Error on server Log Reply with quote

Hi,

can someone explain that what does this error mean? thanks

I/O error 38(Reached the end of the file.) detected during read at offset 0x000003fdbc0000 in file 'N:\xxxxx.vmdf'..
Back to top
View user's profile Send private message
xdai



Joined: 31 Dec 2008
Posts: 69

PostPosted: Tue Apr 05, 2011 6:23 pm    Post subject: Reply with quote

Hi

I found some errors in the log.

05 Apr 11 10:48:46.865 HyperOpenMtfDataFile: FileRecord: 00C52EA0, Failed to open data file: I:\xxx.sqb. Error: 0x2.
05 Apr 11 10:48:46.881 GetRedirectedMTF: FileRecord: 00C52EA0, Failed to open data file. Error: 0x2.
05 Apr 11 10:48:46.881 HyperProcessBlockJob: Failed to load cache data, File offset: 0x3FDBC0000. Error: 2.
05 Apr 11 10:48:46.881 HyperVirtualRead: Failed to read block at offset: 0x3FDBC0000, Length: 0x2000. Error: 2

my questions is since the database already virtual restored, why it still look for the sqb file it try to restore from? because i have new sqb file, then i deleted the old one.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 329
Location: Cambridge, UK

PostPosted: Thu Apr 07, 2011 6:38 pm    Post subject: Reply with quote

The Virtual Restore works by mounting a backup file as a virtual database. This means that the backup file is required for the database to function. The .vmdf and the .vldf files contain only a tiny amount of information, mainly indexes etc to aid with accessing the data in the backup file. So, this almost certainly the reason wny you are receiving the error.

To fix this, you will have to run a new virtual restore on the new .sqb backup file, and refrain from deleting it until you are finished with it.
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