Recovery Model reverts to Simple

We are using Sql Server 2000 and for some reason the recovery model
automatically changes from FULL to simple when we get a notification that are
log file backup job fails. Need suggestions are welcomed...
Is that the msdb database?
"Mike Moore" wrote:

> We are using Sql Server 2000 and for some reason the recovery model
> automatically changes from FULL to simple when we get a notification that are
> log file backup job fails. Need suggestions are welcomed...
|||Yes...you are correct.
"Sasan Saidi" wrote:
[vbcol=seagreen]
> Is that the msdb database?
> "Mike Moore" wrote:
|||Even though you change the recovery model of the msdb database to 'Full', it
will automatically be reset to 'Simple' the next time that SQL Server Agent
is restarted. This is by design to prevent the msdb transaction from growing
to an unmanageable size. You will need to perform only full database backups
on the msdb database.
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Mike Moore" wrote:
[vbcol=seagreen]
> Yes...you are correct.
> "Sasan Saidi" wrote:
|||We are currently doing full database backups on the msdb database.
"Sasan Saidi" wrote:
[vbcol=seagreen]
> Even though you change the recovery model of the msdb database to 'Full', it
> will automatically be reset to 'Simple' the next time that SQL Server Agent
> is restarted. This is by design to prevent the msdb transaction from growing
> to an unmanageable size. You will need to perform only full database backups
> on the msdb database.
> --
> "I saw it work in a cartoon once so I am pretty sure I can do it."
> "Mike Moore" wrote: