473,221 Members | 1,751 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,221 software developers and data experts.

MSDE Maintenance Plan

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
2 3522
"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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Alexey Aksyonenko | last post by:
I know that SQL Servers can be set up to forward alerts to a single SQL Server. I am wondering if same would be true for the Maintenance Plan Reports. Basically, I want to have only one SQL...
5
by: Igor Solodovnikov | last post by:
Hi. I am trying to automatically backup transaction log when error 9002 happened. So i have created appropriate job and alert to catch this error. I have two instances of sql server under Windows...
4
by: elizabeth baker | last post by:
We are developing a fairly simple database to be deployed on the internet. It consists of an artist's works (approx 2600 of them) based on references to books from which his ideas came. Relative...
4
by: nielsonj1976 | last post by:
I am getting a failure on the db backup job of one of my maintenance plans. It is coming back with the generic error message of, "sqlmaint.exe failed. (Error 22029). The step failed." I...
2
by: benamar | last post by:
I am currently maintaining a 8 year old program. It's a VB6 front-end to multiple Access 97 MDB files. Some of our earliest clients have gathered enough data by now, that the MDB files reached...
1
by: microsoft . public . sqlserver | last post by:
I am using SQL server 7.0. After restoring all the databses (Except distribution) Everything seems to be working fine except the backup maintenance plan. I put following detail in the maintenance...
0
by: mmohammed | last post by:
Hi All, I am trying to Schedule a full backup and a transaction log backup in sql server 2005 using Maintenance Plan.My requirement is to schedule these two backups at different time say 10pm and...
11
by: HC | last post by:
I posted this in one of the VB forums but I'm starting to think it might be more appropriate to have it here, since it really seems to be a SQL server (MSDE/Express 2005) problem: Hey, all, I...
9
by: HC | last post by:
Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.