Friday, March 23, 2012

Maintenance Paln Issue

I'm running across a weird issue that I can't figure out. I trying to create
a maintenance plan on one of my SQL 2000 Servers. I run throught the wizard
and get to the screen to setup the backup job and when I go to select the
delete files older than option I notice that that this blank. Typically it
has dyas, hours, and weeks here. The file extension is blank as well. Aslo
the number scroll for number of files does not work correctly down is up.
Any thought on this. This is my only SQl server I've seen this on. I have 5
other SQL servers that work fine when creating a maintenance job.Hi,
This could be problem with dll files of enterprise manager, I think for now
you can create Maintenance plan for this database server on other server.
Regards,
Amol Lembhe
"George Schneider" wrote:
> I'm running across a weird issue that I can't figure out. I trying to create
> a maintenance plan on one of my SQL 2000 Servers. I run throught the wizard
> and get to the screen to setup the backup job and when I go to select the
> delete files older than option I notice that that this blank. Typically it
> has dyas, hours, and weeks here. The file extension is blank as well. Aslo
> the number scroll for number of files does not work correctly down is up.
> Any thought on this. This is my only SQl server I've seen this on. I have 5
> other SQL servers that work fine when creating a maintenance job.|||Is there anyway to resolve this issue?
"Amol Lembhe" wrote:
> Hi,
> This could be problem with dll files of enterprise manager, I think for now
> you can create Maintenance plan for this database server on other server.
> Regards,
> Amol Lembhe
> "George Schneider" wrote:
> > I'm running across a weird issue that I can't figure out. I trying to create
> > a maintenance plan on one of my SQL 2000 Servers. I run throught the wizard
> > and get to the screen to setup the backup job and when I go to select the
> > delete files older than option I notice that that this blank. Typically it
> > has dyas, hours, and weeks here. The file extension is blank as well. Aslo
> > the number scroll for number of files does not work correctly down is up.
> > Any thought on this. This is my only SQl server I've seen this on. I have 5
> > other SQL servers that work fine when creating a maintenance job.

No comments:

Post a Comment