By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,276 Members | 2,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,276 IT Pros & Developers. It's quick & easy.

MSDE Maintenance Plan

P: n/a
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-
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Michael Nostrom" <no*****@binghamton.edu.edu> wrote in message news:<40**********@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
Jul 20 '05 #2

P: n/a
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:60**************************@posting.google.c om...
"Michael Nostrom" <no*****@binghamton.edu.edu> wrote in message
news:<40**********@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...
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.