Monday, February 20, 2012

MSDB and PUBS Databases

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Server.
We setup a SQL backup to run under SQL. We got the messages in the report.
It said "backup cannot be performed on database 'msdb'. This subtask is
ignored." and "Backup cannot be performed on database 'pubs'. This subtask
is ignored". Is it necessary to backup msdb and pubs databases? Thanks.Hi Diane
My guess is that this error is occurring when you try to back up the
transaction log of these databases, as they are in simple mode and the log
cannot be backed up.
Pubs is a sample database used in the documentation examples, and can be
easily rebuilt. It should never need to be backed up at all. MSDB should be
backed up so you can restore information about your tasks, jobs, alerts and
backup history. But you may be backing up the full database already and it
may only be the log backup that is failing.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Server. We setup a SQL backup to run under SQL. We got the messages in
> the report. It said "backup cannot be performed on database 'msdb'. This
> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
> This subtask is ignored". Is it necessary to backup msdb and pubs
> databases? Thanks.
>|||MSDB stores all you job as well as replication information, so backin
this up can save you lot of time in a disastery case. Pubs is jut a
sample database, if you want to you can leave this out, as you can
download the creation script somewhere on the MSDN space of microsoft.
HTH, Jens Suessmeyer.|||Thank you very much, Kalen for your prompt response.
Under Database Maintenance, a complete backup runs once a week and
transaction backup runs everyday. You are right. The error message comes
from the transaction log history. Do you suggest that I ignore the error
messages since I have a complete backup runs every week? I will uncheck the
backup for the PUBS database.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eyN$1mJOGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Diane
> My guess is that this error is occurring when you try to back up the
> transaction log of these databases, as they are in simple mode and the log
> cannot be backed up.
> Pubs is a sample database used in the documentation examples, and can be
> easily rebuilt. It should never need to be backed up at all. MSDB should
> be backed up so you can restore information about your tasks, jobs, alerts
> and backup history. But you may be backing up the full database already
> and it may only be the log backup that is failing.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
>
>|||Thanks for your prompt response, Jens. I just unchecked the backup for the
PUBS database. Thanks.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140713647.322715.266680@.g47g2000cwa.googlegroups.com...
> MSDB stores all you job as well as replication information, so backin
> this up can save you lot of time in a disastery case. Pubs is jut a
> sample database, if you want to you can leave this out, as you can
> download the creation script somewhere on the MSDN space of microsoft.
> HTH, Jens Suessmeyer.
>

No comments:

Post a Comment