Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Problem with Maintenance Plan Wizard

Author  Topic 

satterwk
Starting Member

2 Posts

Posted - 2006-07-06 : 11:24:41
On two servers running at 8.00.818, I have the following issue. I go to create a maintenace plan and select to backup the database. When I try to select "Remove files older than:", the second box is blank (the one that usually holds days, weeks, months, ect.). Well, if I continue and create the maintenance plan without it, it does create the job successfully. If I look at the backup tab for the maintenance plan, it has removed the job schedule. However, the job itself has a schedule and runs successfully. So, my basic issue is I cannot set my backups to expire through the maintenance plan wizard. Has anyone encountered this before?



Kristen
Test

22859 Posts

Posted - 2006-07-10 : 08:09:35
I've encountered it, but only with MSDE. I didn't find a cure, although I think I may have copied a plan from a full-fat version of SQL, with success, but that was ages ago and I'm not 100% sure

Kristen
Go to Top of Page

satterwk
Starting Member

2 Posts

Posted - 2006-07-10 : 09:16:12
These servers are knew to me, and I checked they are running MSDE. Thanks for the reply.
Go to Top of Page
   

- Advertisement -