| Geoff N. Hiten 2006-02-17, 8:23 pm |
| Sounds like a failure notificaiton for transaction log backups. Databases
in SIMPLE recovery cannot have transaction log backups. You might need to
use more than one maintenance plan for all your databases. Create a
maintenance plan that does not attempt to do log backups for databases in
SIMPLE recovery.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Diane Walker" <ett9300@yahoo.com> wrote in message
news:OcQsVBANGHA.1716@TK2MSFTNGP10.phx.gbl...
> We are running SQL Enterprise 2000 on Windows 2003 Standard Edition
> server. We scheduled to run the daily backup job in Database Maintenance
> Plans. The report showed that "Backup cannot be performed on database
> "msdb". This subtask is ignored" and "Backup cannot be performed on
> database "pubs". This subtask is ignored". We would like to know if it is
> necessary to backup the "msdb" and "pubs" databases. If it is, should we
> be concerned about the messages?
>
> Thank you.
>
|