SQL Server Version : 9.00.5057
User Database Maintenance Plan.Full Backup of User Databases which was running successful for quite long time, all of sudden started failing with error below:
------------------------------------------------------------------------------------------------------------------
Date7/28/2015 7:00:01 PM
LogJob History (User Database Maintenance Plan.Full Backup of User Databases)
Step ID1
ServerWsrver
Job NameUser Database Maintenance Plan.Full Backup of User Databases
Step NameFull Backup of User Databases
Duration00:00:34
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: Wsrver\SYSTEM. eter.
End Error Warning: 2015-07-28 19:00:34.91
Code: 0x80019002 Source: OnPostExecute
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.
The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure.
This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:00:01 PM Finished: 7:00:34 PM Elapsed: 33.297 seconds.
The package execution failed. The step failed.
------------------------------------------------------------------------------------------------------------------
Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]