Troubleshooting SQL Server Operating System Error 995

Operating System Error Message

Error: 18210, Severity: 16, State:1
BackupMedium::ReportIoError: write failure on backup device ‘VDI_ DeviceID ‘. Operating system error 995 (The I/O operation has been aborted because of either a thread exit or an application request).

Reason Behind SQL Server Operating System Error 995

There are a number of scenarios when Operating System Error 995 can be experienced by SQL users:

  1. The dominant reason behind the occurrence of os error 995 is the outdated versions of SQLVDI.DLL on SQL Server 2005 or SQL Server 2000 instances.
  2. In case the database backup of SQL server exits abruptly in Activity Monitor while using the NetBackup SQL Server extension, Error 995 can occur.

Workaround To Remove SQL Server Error 995

Whenever the SQL API attempts to create a virtual device, a virtual memory or a physical memory is required for doing the same. However, with the functioning of NT file system for creation of backups, SQL services, and additional programs at the same time, the system does not end up in having enough virtual space or physical memory. When the third and the fourth database of the batch are in the process of being backed up, the NT system backup is completely processed and the memory that is to be used for creation of virtual device is freed.
The OS error code 995 can be removed by splitting the SQL database into multiple policies, which will individually backup few databases at a particular instance. In addition to this, the second method that can be used is increasing the physical or virtual memory, which can overcome this issue.

Conclusion

The above-mentioned error, SQL Server Error 995, at times leads to corruption of SQL Server database. So it is better to repair corrupt SQL .bak file using third party commercial tool.

For more updates:
Subscribe for Blog posts [Click Here]
Follow FB Page [Click Here]
Follow FB Group [Click Here]
For Suggestion & Feedback mail us at gana20m@gmail.com

Rate

Share

Share

Rate

Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis

2009-02-23

1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren

2009-02-17

1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren

2009-02-13

360 reads