Follow sqlserver-dba.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

SQLServer-DBA.com Links

Dba_db2_button

dba-ninja.com

SQL Server DBA Jobs

Backup failures SQLVDI: Loc=CVDS::Close. Desc=Open devices!. ErrorCode=(0).

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..............

 

 


Author: Tom Collins (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

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.

Working...

Post a comment on Backup failures SQLVDI: Loc=CVDS::Close. Desc=Open devices!. ErrorCode=(0).


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer