a msde question (maintenance plan)...

can one use the maintenance plan to do a scheduled backup job for a
msde (sql2k) database? i tried to do it, but there is no schedule
availalbe under the complete backup tab. thank youWhat OS are you running on?
Andrew J. Kelly SQL MVP
"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1112997703.048071.30180@.g14g2000cwa.googlegroups.com...
> can one use the maintenance plan to do a scheduled backup job for a
> msde (sql2k) database? i tried to do it, but there is no schedule
> availalbe under the complete backup tab. thank you
>|||OS is win2k, just like other servers, except on this box, only msde for
sql was installed.|||I assume you are using enterprise manager. Are you sure you have the msde
instance registered under an account with sa privileges? Is SQL Agent
running? Other than that I don't know why it wouldn't show up.
Andrew J. Kelly SQL MVP
"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1113232709.552087.257980@.z14g2000cwz.googlegroups.com...
> OS is win2k, just like other servers, except on this box, only msde for
> sql was installed.
>|||yes, i was running EM from the other server which has a full install of
sql2k.
the msde (and its sql agent) is running under a domain acct with sa
privileges.
i can create a scheduled backup job thru backup wizard, but am
wondering if anyone can do that thru creating a maintenance plan,
because the calendar function under the maintenance is not working, i
don't know if that's the limitation of msde since i have never dealt
with it before (i have always used the full version of sql in the
past).
thank you|||Got me too. I rarely deal with MSDE but I thought you could create a MP
with no problems.
Andrew J. Kelly SQL MVP
"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1113255355.743242.110980@.o13g2000cwo.googlegroups.com...
> yes, i was running EM from the other server which has a full install of
> sql2k.
> the msde (and its sql agent) is running under a domain acct with sa
> privileges.
> i can create a scheduled backup job thru backup wizard, but am
> wondering if anyone can do that thru creating a maintenance plan,
> because the calendar function under the maintenance is not working, i
> don't know if that's the limitation of msde since i have never dealt
> with it before (i have always used the full version of sql in the
> past).
> thank you
>