Thursday, March 8, 2012

Backup options in maintenance plan

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.webservertalk.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.
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.webservertalk.com/t739692.html
"Josh Rolfe" <someone@.microsoft.com> wrote in message
news:O2xOX$JNFHA.1096@.tk2msftngp13.phx.gbl...
>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.webservertalk.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.
>

No comments:

Post a Comment