transaction logs back up through sql maintenance plan

I have a maintenance plan that is supposed to back up the transaction logs
for six different databases from the same server. However when it runs it
only backs up transaction logs for three of them. When I checked in the
backup database task window, I can see that all the six databases have been
checked. I even recreated a new maintenance plan selecting all six databases
again but it only backs up three database. However, I have another plan that
makes a full back up for all the same six databases is working fine.

I have been trying to figure out it since a couple of weeks but without any
resolution. I will appreciate your any inputs.

Sonia

My guess is that at least one of the databases are in simple recovery
model and the MPO stop when it encounters that db.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Sonia" wrote in message

>I have a maintenance plan that is supposed to back up the transaction
>logs
> for six different databases from the same server. However when it
> runs it
> only backs up transaction logs for three of them. When I checked in
> the
> backup database task window, I can see that all the six databases
> have been
> checked. I even recreated a new maintenance plan selecting all six
> databases
> again but it only backs up three database. However, I have another
> plan that
> makes a full back up for all the same six databases is working fine.
>
> I have been trying to figure out it since a couple of weeks but
> without any
> resolution. I will appreciate your any inputs.
>
> Sonia