April 19, 2007 at 4:52 pm
I'm having lots of troubles with getting backups to work on SQL 2005.
I have configured a maintenance task to backup the Database and then scheduled it as a job but i get the following error. I don't understand where to fix this as I have seen the error below in an SSIS Package but this is just a simple Scheduled Job!
ERROR:
The Execution method succeeded, but the number of errors raised (1) 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.
April 20, 2007 at 3:40 am
Trigger,
SQL 2005 maintenace plans are actually SSIS packages stored in the msdb database.That's the reason you get this error. Anyhow the job history should help you identifiying the error.
Markus
[font="Verdana"]Markus Bohse[/font]
June 4, 2007 at 9:46 am
SSIS has this annoying habit where if you create it on your PC and save it on a server it won't work. you have to open the package on the server and recreate the connections since the authentication won't transfer
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply