July 14, 2012 at 11:08 am
Hi, We are using Litespeed for backups.
User db full backup job failed with below error. Anybody encountered this error. please let me know.
Message
Executed as user: domain\adsi. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:07:27 PM Progress: 2012-07-13 20:07:27.76 Source: {693Cxxxxxx-9Fxxx-464xxx-AxxC2-C601DE014xxxx} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2012-07-13 21:28:28.07 Code: 0xC002F210 Source: Back Up Database 1 Execute SQL Task Description: Executing the query "execute master..xp_slssqlmaint N'-D "ALL USER DATA..." failed with the following error: " Msg 60500, Level 16, State 1, Line 0: Error saving data to file. Thread: 5 BACKUP DATABASE is terminating abnormally. A nonrecoverable I/O error occurred on file "VDI_xxxxxx-6xxF-4xxE-Axx0-9xxxxxxxx_0:" 995(The I/O operation has been aborted because of either a thread exit or an application request.). Write on "VDI_xxxExxAC-6D7F-4AxxA44xx9AB1xxx2Axx_3" failed: 10500(failed to retrieve text for this error. Reason: 317) Msg 60500, Level 16, State 1, Line 0: Error saving data to file. Thread: 6 BACKUP DATABASE is terminating abnormally. A nonrecoverable I/O error occurred on file " VDI_xxxExxAC-6D7F-4AxxA44xx9AB1xxx2Axx_3:" 995(The I/O operation has been aborted because of either a thread exit or an application request.). Write on " VDI_xxxExxAC-6D7F-4AxxA44xx9AB1xxx2Axx_385BBC17594E6_0" failed: 10500(failed to retrieve text for this error. Reason: 317) ". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:07:27 PM Finished: 9:28:40 PM Elapsed: 4873.16 seconds. The package execution failed. The step failed.
July 14, 2012 at 12:18 pm
From the error message it looks like the problem may have occurred possibly due to temporary unavailability of the backup media.
you may be able to find additional information in the windows system event log that can confirm ( or rule out) I/O or connectivity issues with the drive to which databases were being backed up to.
July 15, 2012 at 5:37 am
laddu4700 (7/14/2012)
Hi, We are using Litespeed for backups.User db full backup job failed with below error. Anybody encountered this error. please let me know.
Message
Executed as user: domain\adsi. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:07:27 PM Progress: 2012-07-13 20:07:27.76 Source: {693Cxxxxxx-9Fxxx-464xxx-AxxC2-C601DE014xxxx} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2012-07-13 21:28:28.07 Code: 0xC002F210 Source: Back Up Database 1 Execute SQL Task Description: Executing the query "execute master..xp_slssqlmaint N'-D "ALL USER DATA..." failed with the following error: " Msg 60500, Level 16, State 1, Line 0: Error saving data to file. Thread: 5 BACKUP DATABASE is terminating abnormally. A nonrecoverable I/O error occurred on file "VDI_xxxxxx-6xxF-4xxE-Axx0-9xxxxxxxx_0:" 995(The I/O operation has been aborted because of either a thread exit or an application request.). Write on "VDI_xxxExxAC-6D7F-4AxxA44xx9AB1xxx2Axx_3" failed: 10500(failed to retrieve text for this error. Reason: 317) Msg 60500, Level 16, State 1, Line 0: Error saving data to file. Thread: 6 BACKUP DATABASE is terminating abnormally. A nonrecoverable I/O error occurred on file " VDI_xxxExxAC-6D7F-4AxxA44xx9AB1xxx2Axx_3:" 995(The I/O operation has been aborted because of either a thread exit or an application request.). Write on " VDI_xxxExxAC-6D7F-4AxxA44xx9AB1xxx2Axx_385BBC17594E6_0" failed: 10500(failed to retrieve text for this error. Reason: 317) ". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:07:27 PM Finished: 9:28:40 PM Elapsed: 4873.16 seconds. The package execution failed. The step failed.
enable Litespeed logging and re run the backup then post the output from the Litespeed log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2012 at 10:03 am
This error indicates an issue with the network while backing up:
995(The I/O operation has been aborted because of either a thread exit or an application request.).
You see this error when you are backing up to a network location and there are issues with that network connection. If you search on the above error, you will find several articles outlining what you can look at to correct the problem.
Ideally, to fix this - change the process to backup to local storage and then copy to network storage.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply