| Author |
Message |
kevine323
Joined: 27 Jul 2006
Posts: 39
|
 Posted: Wed Sep 28, 2011 7:44 pm Post subject: The operating system returned error 6 when running queries |
 |
|
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 |
|
 |
javen
Joined: 25 May 2010
Posts: 50
|
| Posted: Fri Sep 30, 2011 10:50 am Post subject: |
|
|
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 |
|
|
kevine323
Joined: 27 Jul 2006
Posts: 39
|
| Posted: Fri Sep 30, 2011 2:40 pm Post subject: |
|
|
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 |
|
|
javen
Joined: 25 May 2010
Posts: 50
|
| Posted: Fri Sep 30, 2011 11:32 pm Post subject: |
|
|
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 |
|
|
krizajr
Joined: 03 Apr 2012
Posts: 1
|
| Posted: Tue Apr 03, 2012 6:23 pm Post subject: |
|
|
| 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 |
|
|
|
|
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
