Backup Job Notification Error

I continue to receive a message alert that my backup job
failed for three of my servers every morning while in the
real sense the backups completed successfully. I did
reboot one of the servers but this did not reslove the
issue. Any help on this will be appreaciated please.Are these databases in Simple recovery mode? If so, any
transaction log backup will fail, and a SQL Maintenance
Plan will show an overall failure to execute (although the
full backups will run).
Also, have you tried restoring one of the backups that
completed? Another thing to check is to make sure the job
doesn't have additional steps, or operator alerts, or any
of the optional settings on. If execution of any of the
other activities should occur, overall failure of the job
may be flagged.
Also, in the job history, what is the exact error you're
receiving -- that is, when the Show Details option is
checked?
>--Original Message--
>I continue to receive a message alert that my backup job
>failed for three of my servers every morning while in the
>real sense the backups completed successfully. I did
>reboot one of the servers but this did not reslove the
>issue. Any help on this will be appreaciated please.
>.
>|||here is the error message. any new lead.
The job failed. The Job was invoked by Schedule 7
(Schedule 1). The last step to run was step 1 (Step 1).
Thanks,
Aboki.
>--Original Message--
>Are these databases in Simple recovery mode? If so, any
>transaction log backup will fail, and a SQL Maintenance
>Plan will show an overall failure to execute (although
the
>full backups will run).
>Also, have you tried restoring one of the backups that
>completed? Another thing to check is to make sure the
job
>doesn't have additional steps, or operator alerts, or any
>of the optional settings on. If execution of any of the
>other activities should occur, overall failure of the job
>may be flagged.
>Also, in the job history, what is the exact error you're
>receiving -- that is, when the Show Details option is
>checked?
>>--Original Message--
>>I continue to receive a message alert that my backup job
>>failed for three of my servers every morning while in
the
>>real sense the backups completed successfully. I did
>>reboot one of the servers but this did not reslove the
>>issue. Any help on this will be appreaciated please.
>>.
>.
>|||Here are the details when show step details is selected.
Executed as user: BHCS\sqlsrv. sqlmaint.exe failed.
[SQLSTATE 42000] (Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 7
(Schedule 1). The last step to run was step 1 (Step 1).
Thanks,
Aboki.
>--Original Message--
>here is the error message. any new lead.
>The job failed. The Job was invoked by Schedule 7
>(Schedule 1). The last step to run was step 1 (Step 1).
>
>Thanks,
>Aboki.
>
>>--Original Message--
>>Are these databases in Simple recovery mode? If so, any
>>transaction log backup will fail, and a SQL Maintenance
>>Plan will show an overall failure to execute (although
>the
>>full backups will run).
>>Also, have you tried restoring one of the backups that
>>completed? Another thing to check is to make sure the
>job
>>doesn't have additional steps, or operator alerts, or
any
>>of the optional settings on. If execution of any of the
>>other activities should occur, overall failure of the
job
>>may be flagged.
>>Also, in the job history, what is the exact error you're
>>receiving -- that is, when the Show Details option is
>>checked?
>>--Original Message--
>>I continue to receive a message alert that my backup
job
>>failed for three of my servers every morning while in
>the
>>real sense the backups completed successfully. I did
>>reboot one of the servers but this did not reslove the
>>issue. Any help on this will be appreaciated please.
>>.
>>.
>.
>|||Check to ensure it is the backup step which is failing... Often the step
PRIOR to backup fails... That would be doing the DBCC and having selected
"Repair" option.. This option requires the db to be in single-user mode. If
users are in the db, this step fails...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Aboki" <hcokoli@.yahoo.com> wrote in message
news:426301c4731f$6ac87900$a401280a@.phx.gbl...
> I continue to receive a message alert that my backup job
> failed for three of my servers every morning while in the
> real sense the backups completed successfully. I did
> reboot one of the servers but this did not reslove the
> issue. Any help on this will be appreaciated please.