DB Maint plans incorrect in MSDE

I have a SQL 2K application that I have been working on copying to a MSDE2k
machine. As part of setting the DB up on a new machine, I tried to set up a
DB Maintenance plan in Enterprise Manager. When I got to the pages in the
wizard that setup removing old backups, I found that the pulldown list of
units (days, weeks, months, etc.) was completely blank when I tried to make
a selection. Curious, I checked some other MSDE servers and found that they
all either did the same thing, or didn't have the Database Maintenance Plans
selection even listed in EM. Of the ones that do have maintenance plans
listed, it seems like all will remove the schedule from the backups on
saving - i.e. if I create a plan with a backup schedule (either via the
wizard or the properties pages) and save it, the schedule will be blank the
next time I open the plan.
Can anyone tell me what is going on here and how to fix it? Are maintenance
plans not really a part of MSDE?
TIA
Ron LounsburyWhat service pack? MSDE 2000 does not install Sqlmaint.exe
which is used for database maintenance plans. This issue was
fixed with SP 1. See the following for more info:
http://support.microsoft.com/?id=295022
-Sue
On Wed, 24 Mar 2004 15:21:02 -0500, "Ron Lounsbury"
<rlounsbury@.bogusAddress.com> wrote:

>I have a SQL 2K application that I have been working on copying to a MSDE2k
>machine. As part of setting the DB up on a new machine, I tried to set up
a
>DB Maintenance plan in Enterprise Manager. When I got to the pages in the
>wizard that setup removing old backups, I found that the pulldown list of
>units (days, weeks, months, etc.) was completely blank when I tried to make
>a selection. Curious, I checked some other MSDE servers and found that the
y
>all either did the same thing, or didn't have the Database Maintenance Plan
s
>selection even listed in EM. Of the ones that do have maintenance plans
>listed, it seems like all will remove the schedule from the backups on
>saving - i.e. if I create a plan with a backup schedule (either via the
>wizard or the properties pages) and save it, the schedule will be blank the
>next time I open the plan.
>Can anyone tell me what is going on here and how to fix it? Are maintenanc
e
>plans not really a part of MSDE?
>TIA
>Ron Lounsbury
>|||Sue
Sorry, I forgot to mention that. It is SP3.
Thanks,
Ron
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:ibs360dus2nbgtv77gah0br5t9uv4lb4ap@.
4ax.com...
> What service pack? MSDE 2000 does not install Sqlmaint.exe
> which is used for database maintenance plans. This issue was
> fixed with SP 1. See the following for more info:
> http://support.microsoft.com/?id=295022
> -Sue
> On Wed, 24 Mar 2004 15:21:02 -0500, "Ron Lounsbury"
> <rlounsbury@.bogusAddress.com> wrote:
>
MSDE2k
up a
the
make
they
Plans
the
maintenance
>|||Ron,
I know I've read about a similar issue but I didn't find a
KB article on it. Anyway...it probably stems from a missing
registry value for the backup directory.
On a default instance, you would add a new string value to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer
The new string value is BackupDirectory
The data value for this is the path to your backup
directory. The default would be
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP
-Sue
On Wed, 24 Mar 2004 15:51:12 -0500, "Ron Lounsbury"
<rlounsbury@.bogusAddress.com> wrote:

>Sue
> Sorry, I forgot to mention that. It is SP3.
>Thanks,
>Ron
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:ibs360dus2nbgtv77gah0br5t9uv4lb4ap@.
4ax.com...
>MSDE2k
>up a
>the
>make
>they
>Plans
>the
>maintenance
>|||Sue
Thanks, I'll give that a try.
Ron L
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:3604605mfu2viaevss1sanduj96inm2qdt@.
4ax.com...
> Ron,
> I know I've read about a similar issue but I didn't find a
> KB article on it. Anyway...it probably stems from a missing
> registry value for the backup directory.
> On a default instance, you would add a new string value to:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer
> The new string value is BackupDirectory
> The data value for this is the path to your backup
> directory. The default would be
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP
> -Sue
> On Wed, 24 Mar 2004 15:51:12 -0500, "Ron Lounsbury"
> <rlounsbury@.bogusAddress.com> wrote:
>
set
of
that
plans
the
blank
>|||Sue
Thanks. That was it.
Ron L
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:3604605mfu2viaevss1sanduj96inm2qdt@.
4ax.com...
> Ron,
> I know I've read about a similar issue but I didn't find a
> KB article on it. Anyway...it probably stems from a missing
> registry value for the backup directory.
> On a default instance, you would add a new string value to:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer
> The new string value is BackupDirectory
> The data value for this is the path to your backup
> directory. The default would be
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP
> -Sue
> On Wed, 24 Mar 2004 15:51:12 -0500, "Ron Lounsbury"
> <rlounsbury@.bogusAddress.com> wrote:
>
set
of
that
plans
the
blank
>