Database Maintenance Plan - Can't select Remove Files Older Than .

Hello,
Having a strange problem and hoping that someone else has seen this before.
Have an up and running SQL Server 2000 (no problems that I can detect).
Trying to create a maintenance plan to backup the databases each night.
Start the maintenance plan wizard and get to the "Specify Backup Disk
Directory" screen and the "Remove Files Older Than" drop down box is blank,
can't select "Weeks", "Days", etc.
Have re-installed the Enterprise Manager tools and upgraded to SQL SP4, with
no change.
Thanks in advance for any help or insight.Hi
Have you tried using the tools on a different machine or against a different
server?
John
"DHood" wrote:
> Hello,
> Having a strange problem and hoping that someone else has seen this before.
> Have an up and running SQL Server 2000 (no problems that I can detect).
> Trying to create a maintenance plan to backup the databases each night.
> Start the maintenance plan wizard and get to the "Specify Backup Disk
> Directory" screen and the "Remove Files Older Than" drop down box is blank,
> can't select "Weeks", "Days", etc.
> Have re-installed the Enterprise Manager tools and upgraded to SQL SP4, with
> no change.
> Thanks in advance for any help or insight.|||hi dhood,
i have the same problem!
is it possible that this problem exists since you updated to sp4?
because in my case all sql2000sp4 have this problem, sp3 not...
with mangerstudio from sql 2005 this problem is gone, but others appear...
greets
jeff
"DHood" <DHood@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0563B8C1-891B-4AF1-B49C-6EF3E39BA511@.microsoft.com...
> Hello,
> Having a strange problem and hoping that someone else has seen this
> before.
> Have an up and running SQL Server 2000 (no problems that I can detect).
> Trying to create a maintenance plan to backup the databases each night.
> Start the maintenance plan wizard and get to the "Specify Backup Disk
> Directory" screen and the "Remove Files Older Than" drop down box is
> blank,
> can't select "Weeks", "Days", etc.
> Have re-installed the Enterprise Manager tools and upgraded to SQL SP4,
> with
> no change.
> Thanks in advance for any help or insight.|||No, I definiately had the problem before I upgraded to SP4. I just tried the
SP4 upgrade in hopes that it would fix the problem.
"j.goines" wrote:
> hi dhood,
> i have the same problem!
> is it possible that this problem exists since you updated to sp4?
> because in my case all sql2000sp4 have this problem, sp3 not...
> with mangerstudio from sql 2005 this problem is gone, but others appear...
> greets
> jeff
> "DHood" <DHood@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:0563B8C1-891B-4AF1-B49C-6EF3E39BA511@.microsoft.com...
> > Hello,
> >
> > Having a strange problem and hoping that someone else has seen this
> > before.
> >
> > Have an up and running SQL Server 2000 (no problems that I can detect).
> > Trying to create a maintenance plan to backup the databases each night.
> > Start the maintenance plan wizard and get to the "Specify Backup Disk
> > Directory" screen and the "Remove Files Older Than" drop down box is
> > blank,
> > can't select "Weeks", "Days", etc.
> >
> > Have re-installed the Enterprise Manager tools and upgraded to SQL SP4,
> > with
> > no change.
> >
> > Thanks in advance for any help or insight.
>
>|||I have tried it against another server, same problem. I have tried accessing
the problem server from the tools on another server and everything looks
normal. So it appears to be something specific on that machine.
"John Bell" wrote:
> Hi
> Have you tried using the tools on a different machine or against a different
> server?
> John
> "DHood" wrote:
> > Hello,
> >
> > Having a strange problem and hoping that someone else has seen this before.
> >
> > Have an up and running SQL Server 2000 (no problems that I can detect).
> > Trying to create a maintenance plan to backup the databases each night.
> > Start the maintenance plan wizard and get to the "Specify Backup Disk
> > Directory" screen and the "Remove Files Older Than" drop down box is blank,
> > can't select "Weeks", "Days", etc.
> >
> > Have re-installed the Enterprise Manager tools and upgraded to SQL SP4, with
> > no change.
> >
> > Thanks in advance for any help or insight.|||Hi
It certainly seems that a dll or somthing is corrupted on that machine. Did
you remove the shared dlls when you un-installed the client tools?
John
"DHood" wrote:
> No, I definiately had the problem before I upgraded to SP4. I just tried the
> SP4 upgrade in hopes that it would fix the problem.
> "j.goines" wrote:
> > hi dhood,
> > i have the same problem!
> > is it possible that this problem exists since you updated to sp4?
> > because in my case all sql2000sp4 have this problem, sp3 not...
> > with mangerstudio from sql 2005 this problem is gone, but others appear...
> >
> > greets
> > jeff
> >
> > "DHood" <DHood@.discussions.microsoft.com> schrieb im Newsbeitrag
> > news:0563B8C1-891B-4AF1-B49C-6EF3E39BA511@.microsoft.com...
> > > Hello,
> > >
> > > Having a strange problem and hoping that someone else has seen this
> > > before.
> > >
> > > Have an up and running SQL Server 2000 (no problems that I can detect).
> > > Trying to create a maintenance plan to backup the databases each night.
> > > Start the maintenance plan wizard and get to the "Specify Backup Disk
> > > Directory" screen and the "Remove Files Older Than" drop down box is
> > > blank,
> > > can't select "Weeks", "Days", etc.
> > >
> > > Have re-installed the Enterprise Manager tools and upgraded to SQL SP4,
> > > with
> > > no change.
> > >
> > > Thanks in advance for any help or insight.
> >
> >
> >|||No, I didn't remove any files manually. Do you know what and where they are?
"John Bell" wrote:
> Hi
> It certainly seems that a dll or somthing is corrupted on that machine. Did
> you remove the shared dlls when you un-installed the client tools?
> John
> "DHood" wrote:
> > No, I definiately had the problem before I upgraded to SP4. I just tried the
> > SP4 upgrade in hopes that it would fix the problem.
> >
> > "j.goines" wrote:
> >
> > > hi dhood,
> > > i have the same problem!
> > > is it possible that this problem exists since you updated to sp4?
> > > because in my case all sql2000sp4 have this problem, sp3 not...
> > > with mangerstudio from sql 2005 this problem is gone, but others appear...
> > >
> > > greets
> > > jeff
> > >
> > > "DHood" <DHood@.discussions.microsoft.com> schrieb im Newsbeitrag
> > > news:0563B8C1-891B-4AF1-B49C-6EF3E39BA511@.microsoft.com...
> > > > Hello,
> > > >
> > > > Having a strange problem and hoping that someone else has seen this
> > > > before.
> > > >
> > > > Have an up and running SQL Server 2000 (no problems that I can detect).
> > > > Trying to create a maintenance plan to backup the databases each night.
> > > > Start the maintenance plan wizard and get to the "Specify Backup Disk
> > > > Directory" screen and the "Remove Files Older Than" drop down box is
> > > > blank,
> > > > can't select "Weeks", "Days", etc.
> > > >
> > > > Have re-installed the Enterprise Manager tools and upgraded to SQL SP4,
> > > > with
> > > > no change.
> > > >
> > > > Thanks in advance for any help or insight.
> > >
> > >
> > >|||Hi
When you un-install it usually prompts to remove shared files. You may want
to see what dlls are loaded when you start the application.
John
"DHood" wrote:
> No, I didn't remove any files manually. Do you know what and where they are?
> "John Bell" wrote:
> > Hi
> >
> > It certainly seems that a dll or somthing is corrupted on that machine. Did
> > you remove the shared dlls when you un-installed the client tools?
> >
> > John
> >
> > "DHood" wrote:
> >
> > > No, I definiately had the problem before I upgraded to SP4. I just tried the
> > > SP4 upgrade in hopes that it would fix the problem.
> > >
> > > "j.goines" wrote:
> > >
> > > > hi dhood,
> > > > i have the same problem!
> > > > is it possible that this problem exists since you updated to sp4?
> > > > because in my case all sql2000sp4 have this problem, sp3 not...
> > > > with mangerstudio from sql 2005 this problem is gone, but others appear...
> > > >
> > > > greets
> > > > jeff
> > > >
> > > > "DHood" <DHood@.discussions.microsoft.com> schrieb im Newsbeitrag
> > > > news:0563B8C1-891B-4AF1-B49C-6EF3E39BA511@.microsoft.com...
> > > > > Hello,
> > > > >
> > > > > Having a strange problem and hoping that someone else has seen this
> > > > > before.
> > > > >
> > > > > Have an up and running SQL Server 2000 (no problems that I can detect).
> > > > > Trying to create a maintenance plan to backup the databases each night.
> > > > > Start the maintenance plan wizard and get to the "Specify Backup Disk
> > > > > Directory" screen and the "Remove Files Older Than" drop down box is
> > > > > blank,
> > > > > can't select "Weeks", "Days", etc.
> > > > >
> > > > > Have re-installed the Enterprise Manager tools and upgraded to SQL SP4,
> > > > > with
> > > > > no change.
> > > > >
> > > > > Thanks in advance for any help or insight.
> > > >
> > > >
> > > >|||See if this helps--
If you profile when on that form you should see the following:
xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory'
I was getting the same problem that you were, and discovered that this proc
was returning an error b/c the registry key did not exist. I entered key and
a valid value and the problem went away.
I know several people have posted on this same issue, so I hope someone gets
some value out of this.
JIM BOUTIT
MCSE MCDBA
"John Bell" wrote:
> Hi
> When you un-install it usually prompts to remove shared files. You may want
> to see what dlls are loaded when you start the application.
> John
>
> "DHood" wrote:
> > No, I didn't remove any files manually. Do you know what and where they are?
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > It certainly seems that a dll or somthing is corrupted on that machine. Did
> > > you remove the shared dlls when you un-installed the client tools?
> > >
> > > John
> > >
> > > "DHood" wrote:
> > >
> > > > No, I definiately had the problem before I upgraded to SP4. I just tried the
> > > > SP4 upgrade in hopes that it would fix the problem.
> > > >
> > > > "j.goines" wrote:
> > > >
> > > > > hi dhood,
> > > > > i have the same problem!
> > > > > is it possible that this problem exists since you updated to sp4?
> > > > > because in my case all sql2000sp4 have this problem, sp3 not...
> > > > > with mangerstudio from sql 2005 this problem is gone, but others appear...
> > > > >
> > > > > greets
> > > > > jeff
> > > > >
> > > > > "DHood" <DHood@.discussions.microsoft.com> schrieb im Newsbeitrag
> > > > > news:0563B8C1-891B-4AF1-B49C-6EF3E39BA511@.microsoft.com...
> > > > > > Hello,
> > > > > >
> > > > > > Having a strange problem and hoping that someone else has seen this
> > > > > > before.
> > > > > >
> > > > > > Have an up and running SQL Server 2000 (no problems that I can detect).
> > > > > > Trying to create a maintenance plan to backup the databases each night.
> > > > > > Start the maintenance plan wizard and get to the "Specify Backup Disk
> > > > > > Directory" screen and the "Remove Files Older Than" drop down box is
> > > > > > blank,
> > > > > > can't select "Weeks", "Days", etc.
> > > > > >
> > > > > > Have re-installed the Enterprise Manager tools and upgraded to SQL SP4,
> > > > > > with
> > > > > > no change.
> > > > > >
> > > > > > Thanks in advance for any help or insight.
> > > > >
> > > > >
> > > > >