sql server msde: Backup options in maintenance plan -- sql server msde

Backup options in maintenance plan

Josh Rolfe
3/29/2005 1:42:34 PM

sql server msde: I am trying to create a maintenance plan to backup my SQL Desktop Engine
(MSDE 2000) databases using enterprise manager. Everything goes fine in the
maintenance wizard until I get to the "Specify Backup Disk Directory"
screen. On this screen, the drop down box next to "Remove files older
than:" is blank, where it would normally say days, weeks, etc. If I finish
making the plan, when I go back in the path is gone as well as the schedule.
This is only happening on our MSDE SP3 installations. We also have SQL
Server 2000 SP3 and MSDE 7 installed in our organization on different
servers. They do not have this problem. I found someone else with this
problem on the internet at http://www.dbforums.com/t1108273.html but the
solution describes how to execute an existing maintenance plan. I want to
know why I can't create one using EM.

Re: Backup options in maintenance plan

Josh Rolfe
3/30/2005 12:12:13 PM

OK, I found the solution for this (at least the workaround until Microsoft
fixes the problem). You need to add a registry entry to the server running
MSDE. Details can be found at:
http://www.dbforums.com/t739692.html

[quoted text, click to view]