Red Gate forums :: View topic - The operating system returned error 6 when running queries
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

The operating system returned error 6 when running queries

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



Joined: 27 Jul 2006
Posts: 39

PostPosted: Wed Sep 28, 2011 7:44 pm    Post subject: The operating system returned error 6 when running queries Reply with quote

Every time I restore a native SQL backup using Virtual Backup I end up with an operating system error the next day after the restore. When the database is first restored, it works great and is easily queried, but after a day the database becomes unusable. This is on all databases restored using Virtual Restore, but all other databases restored natively (with mdf/ldf extensions rahter than vmdf/vld) work as they should. Any ideas?

Error message below:

The operating system returned error 6(The handle is invalid.) to SQL Server during a read at offset 0x00000000150000 in file 'C:\<Directory>\<FileName>.vmdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
_________________
Kevin Eckart
Database Administrator
USA Truck, Inc
Kevin.Eckart@usa-truck.com
http://kevine323.blogspot.com/
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger
javen



Joined: 25 May 2010
Posts: 50

PostPosted: Fri Sep 30, 2011 10:50 am    Post subject: Reply with quote

Has the system been rebooted after the VR at some stage? Also are there any volumes on the system that may be unavailable between the time it worked and the time when it did not (eg USB volumes being removed)?
_________________
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
Back to top
View user's profile Send private message
kevine323



Joined: 27 Jul 2006
Posts: 39

PostPosted: Fri Sep 30, 2011 2:40 pm    Post subject: Reply with quote

Thanks for the quick reply. There have been no reboots and no volumes on the server that have been removed. FYI: The VR log file is very large and shows quite a few CRC errors like below:
19 Sep 11 13:52:13.443 CheckMtfBlock: FileRecord: 00000000293F7E40, Crc mismatch on firstCrcInfo->Offset: 0x0.
_________________
Kevin Eckart
Database Administrator
USA Truck, Inc
Kevin.Eckart@usa-truck.com
http://kevine323.blogspot.com/
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger
javen



Joined: 25 May 2010
Posts: 50

PostPosted: Fri Sep 30, 2011 11:32 pm    Post subject: Reply with quote

We will need to get this log file from you, we will make contact via support
_________________
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
Back to top
View user's profile Send private message
krizajr



Joined: 03 Apr 2012
Posts: 1

PostPosted: Tue Apr 03, 2012 6:23 pm    Post subject: Reply with quote

I'm also seeing this issue. Same error message. No reboot, no changes. What was the outcome of your review? Is the database recoverable?
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