On one of the production servers Tivoli Data Protection (TDP) for MSSQL databases was recently installed. It was working as desired ever since. But today, SQL Server Error Log had one entry.
spid193 BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'TDPSQL-000016E0-0000'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.)
While trying to take the backup of few databases, TDP has failed and these entries were logged. The instance is running on SQL Server 2005 + CU 8 for SP3 (9.00.4285). While looking for a resolution I stumbled upon this article from Microsoft and the possible cause is stated as
This problem occurs because of a race condition. The race condition incorrectly logs the event in the Application log.
This article referred to a hotfix for SQL Server 2005 SP2. As stated earlier, this server was running on SP3 + CU8. However, to confirm that the version of sqlvdi.dll is the correct one, I navigated to
C:Program FilesMicrosoft SQL Server80COM and found the version was 2000.85.2312.0 which is higher than the one mentioned in the KB article.
Moreover, the backup was running fine all these days and nothing had changed in the environment that would have caused a version conflict.
Then this article from Microsoft stated that the above error is a generic one and in most of the cases this happens because of the backup destination being full. This statement sounded reasonable to me. The fact that today’s backup failed for only few databases, substantiated this statement.
Now a ticket has been raised with the Backup Team and most likely the backup will be successful tomorrow !