Backup job

hello everyone, I have a backup maintenance job running on
my server, it is showing the failed prompt, but when i
checked the log it is showing the database backed up
successfully..
What can i do to get rid of the failed status and what may
be causing this'
Thank you
ATI've seen it because it is trying to fix indexes while users are online and
using them. Set the index optimizations in seperate plans than your backups
to make the errors more clear.
Christian Smith
"AT" <adigga3@.hotmail.com> wrote in message
news:e4a601c3f015$ff272200$a601280a@.phx.gbl...
> hello everyone, I have a backup maintenance job running on
> my server, it is showing the failed prompt, but when i
> checked the log it is showing the database backed up
> successfully..
> What can i do to get rid of the failed status and what may
> be causing this'
> Thank you
> AT|||Thanks Christian, but the backup job still shows that it
backed up when I look at log or history files. will this
be a problem? how do i clear the "Red X" sign that appears?
>--Original Message--
>I've seen it because it is trying to fix indexes while
users are online and
>using them. Set the index optimizations in seperate
plans than your backups
>to make the errors more clear.
>Christian Smith
>"AT" <adigga3@.hotmail.com> wrote in message
>news:e4a601c3f015$ff272200$a601280a@.phx.gbl...
on
may
>
>.
>|||Specify a report file for the maint job and check for the real error message
in that report file.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"AT" <anonymous@.discussions.microsoft.com> wrote in message
news:e5df01c3f02a$e895cd10$a601280a@.phx.gbl...
> Thanks Christian, but the backup job still shows that it
> backed up when I look at log or history files. will this
> be a problem? how do i clear the "Red X" sign that appears?
> users are online and
> plans than your backups
> on
> may