October 16, 2018 at 9:53 am
We recenlty did a migration of Archive DB's and after that I started seeing this message and one of the maintenance plan is failing.
In addition to that I also see multiple errors in logs where it says 'login failed : password mismatch for user 'sa'. However few jobs are running fine with 'sa'.
Please let me know your thoughts as to why backup job is failing?
Message
Executed as user: user1\MDB1. parameter. End Error Warning: 2018-10-14 07:46:36.70 Code: 0x80019002 Source: Incremental Backup Plan 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:45:00 AM Finished: 7:46:36 AM Elapsed: 96.125 seconds. The package execution failed. The step failed.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply