I'm trying to configure my MSDE 2000 installation to dump all databases
and transaction logs to disk every night to be backed up by our backup
software. All goes great in configuring the maintenance plan until I get to
the retention part. I want to configure the backup plan so that it'll delete
OLD backup older than 2 days. When I click the 'Remove files older than" box
and choose 2, but there's nothing in the drop-down box where
Hours/Days/Months should be..
If I fudge it and try to edit the job nothing has saved and the job
fails.. Any help is greatly appreciated..
Thanks,
-Mike-"Michael Nostrom" <nostrom@.binghamton.edu.edu> wrote in message news:<40bdfa79$1_2@.bingnews.binghamton.edu>...
> Hello,
> I'm trying to configure my MSDE 2000 installation to dump all databases
> and transaction logs to disk every night to be backed up by our backup
> software. All goes great in configuring the maintenance plan until I get to
> the retention part. I want to configure the backup plan so that it'll delete
> OLD backup older than 2 days. When I click the 'Remove files older than" box
> and choose 2, but there's nothing in the drop-down box where
> Hours/Days/Months should be..
> If I fudge it and try to edit the job nothing has saved and the job
> fails.. Any help is greatly appreciated..
> Thanks,
> -Mike-
I have no idea what the issue is, but perhaps you can give some more
information. Are you using the latest version of MSDE? And which
operating system are you working with? Have you been able to create a
plan successfully on an MSSQL server (if you have one, but since you
have EM I guess you do)? Have you tried reinstalling the client tools,
and have you applied the latest servicepack to the client tools?
Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message
news:60cd0137.0406022246.77874ec3@.posting.google.c om...
"Michael Nostrom" <nostrom@.binghamton.edu.edu> wrote in message
news:<40bdfa79$1_2@.bingnews.binghamton.edu>...
> Hello,
> I'm trying to configure my MSDE 2000 installation to dump all
databases
> and transaction logs to disk every night to be backed up by our backup
> software. All goes great in configuring the maintenance plan until I get
to
> the retention part. I want to configure the backup plan so that it'll
delete
> OLD backup older than 2 days. When I click the 'Remove files older than"
box
> and choose 2, but there's nothing in the drop-down box where
> Hours/Days/Months should be..
> If I fudge it and try to edit the job nothing has saved and the job
> fails.. Any help is greatly appreciated..
> Thanks,
> -Mike-
I have no idea what the issue is, but perhaps you can give some more
information. Are you using the latest version of MSDE? And which
operating system are you working with? Have you been able to create a
plan successfully on an MSSQL server (if you have one, but since you
have EM I guess you do)? Have you tried reinstalling the client tools,
and have you applied the latest servicepack to the client tools?
Simon
Windows 2000 SP4
MSDE 2000 (8.00.818) SP3
EM Tools is installed on my workstation for managing other SQL Servers.
I am able to do a simple Dump to Disk, but I want to schedule nightly dumps.
Actually I manually modified the 'Steps' of the backup job and added the
necessary code to get the job to complete successfully..
Thanks anyway Simon...
