The operating system returned error 6 when running queries

SQL Virtual Restore: Rapidly mount live, fully functional databases direct from backups

Moderators: eddie davis, Colin Millerchip, fionag

The operating system returned error 6 when running queries

Postby kevine323 » Wed Sep 28, 2011 7:44 pm

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/
kevine323
 
Posts: 39
Joined: Thu Jul 27, 2006 10:23 pm

Postby javen » Fri Sep 30, 2011 10:50 am

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
javen
 
Posts: 50
Joined: Tue May 25, 2010 12:10 am

Postby kevine323 » Fri Sep 30, 2011 2:40 pm

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/
kevine323
 
Posts: 39
Joined: Thu Jul 27, 2006 10:23 pm

Postby javen » Fri Sep 30, 2011 11:32 pm

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
javen
 
Posts: 50
Joined: Tue May 25, 2010 12:10 am

Postby krizajr » Tue Apr 03, 2012 6:23 pm

I'm also seeing this issue. Same error message. No reboot, no changes. What was the outcome of your review? Is the database recoverable?
krizajr
 
Posts: 1
Joined: Tue Apr 03, 2012 6:02 pm


Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 0 guests