22 January,2017 by Tom Collins
Question: I’m getting intermittent backup issues with the following error messages appearing in the Event Viewer error logs
SQLVDI: Loc=CVDS::Close. Desc=Open devices!. ErrorCode=(0). Process=10024. Thread=7312. Client. Instance=MYINST. VD=Global\my_server_inst_unique_guid-SQL_SQLVDIMemoryName_0.
There are related errors in the SQL Server Error Logs
BackupIoRequest::ReportIoError: write failure on backup device 'vd_1'. Operating system error 995(failed to retrieve text for this error. Reason: 15105).
How can I progress with troubleshooting?
I've read Not enough storage is available to complete this operation (SQL ... which discusses a problem where there are not enough large enough contiguous block of free memory.
Answer: These issue can be mystifying and notoriously difficult to pin down. My initial thoughts are:
a)Is there another process locking those files ?
b)Is the server hitting a virtual memory limit? Read this post on how to gather memory details SQL Server Performance ,memory pressure and memory usage or SQL Server – Measuring SQL memory usage
The OS error 995 says that The I/O operation has been aborted because of either a thread exit or an applica tion request.
I’ve always found this message not very useful.
First, doublecheck the remainder of the backups complete OK.
Second, Does the error occur every day or is there a regular pattern ?
I will add more this post tomorrow..............
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |