Database backup fails

Hi,
I have three databases on a SQL Server. I have created three separate
maintenance plans for the three databases. The plans are exactly identical
except for the time of the complete backup. The complete backup of all the
three databases happens every night at different times and the transaction
log backup takes place every 3 hours during 11 AM and 5 PM. However, from the
first day onwards, plan for database one always fails while the plans for the
other two databases execute successfully. I don't know what I am doing
incorrectly. Can someone please let me know how to figure out the reason for
the failure?
Sharman,
You can view the error log and the event log for more details. In addition
you can right click the maintenance plan and choose Maintenance Plan
History...
Also make sure you have not selected the 'Attempt to repair any minor
problems' checkbox. Requires the DB to be in single user mode.
HTH
Jerry
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:376FA452-F24E-4D3B-8AB2-9AD221645CB4@.microsoft.com...
> Hi,
> I have three databases on a SQL Server. I have created three separate
> maintenance plans for the three databases. The plans are exactly identical
> except for the time of the complete backup. The complete backup of all the
> three databases happens every night at different times and the transaction
> log backup takes place every 3 hours during 11 AM and 5 PM. However, from
> the
> first day onwards, plan for database one always fails while the plans for
> the
> other two databases execute successfully. I don't know what I am doing
> incorrectly. Can someone please let me know how to figure out the reason
> for
> the failure?
>