Friday, March 30, 2012

maintenance plan in enterprise manager not functioning quite right

hello,
wondering if anyone could give me some insight. i've created two
maintenance plans for each of two sql servers (production and test). the
first of each is supposed to check the master, model, and msdb dbs and then
do a complete backup of them as well as their transaction logs. the second
of each does the same for all my user dbs.
all dbs are set to recovery model full except for the master and msdb dbs.
the plan is basically working, except that it is skipping a few of the user
dbs, and it is also skipping the master and msdb dbs on both servers. that
is, i see no mention of them in the logs, and no backup files are created on
disk.
what am i doing wrong?
appreciated,
matthew
Well it can't issue a log backup on Master and MSDB since they are in simple
mode. My guess is the others are as well.
Andrew J. Kelly SQL MVP
"matthew c. harad" <matthewcharad@.discussions.microsoft.com> wrote in
message news:8EC5F016-98C3-4712-8F4D-F1B84B2A20E5@.microsoft.com...
> hello,
> wondering if anyone could give me some insight. i've created two
> maintenance plans for each of two sql servers (production and test). the
> first of each is supposed to check the master, model, and msdb dbs and
then
> do a complete backup of them as well as their transaction logs. the
second
> of each does the same for all my user dbs.
> all dbs are set to recovery model full except for the master and msdb dbs.
> the plan is basically working, except that it is skipping a few of the
user
> dbs, and it is also skipping the master and msdb dbs on both servers.
that
> is, i see no mention of them in the logs, and no backup files are created
on
> disk.
> what am i doing wrong?
> appreciated,
> matthew

No comments:

Post a Comment