Does MSDE support SQL Server's DB Maintenance Plans?

[GaryK]

The subject sort of sums up my question.

I have a Windows 2003 Server running MSDE. I use Enterprise Manager to manage my databases and everything seems to work except whenever I try to schedule any type of DB Maintenance Plan the information I enter isn't saved. The plan itself is saved but when I edit it all the information is set to the defaults for a new plan instead of the information I entered.

So I'm thinking DB Maintenance Plans aren't really supported in MSDE. Am I right?

~gary.

[KyleMulligan]

Yes, MSDE supports database maintenance plans, provided you have the SQL Server Agent running as well as the MSSSQL service. I have one configured that optimizes and backs up all my databases on a weekly basis. I just double-checked and I can edit existing maintenance plans.

Are you sure it's not another issue with your firewall rules? :p BTW, I'll go ahead and respond to your email, but point to this thread (in case you haven't already checked it). :)

[GaryK]

I'll be submitting a ticket shortly, Kyle. :)

I just did some investigative work based on your statement that the Database Maintenance Plan (DBMP) does work in MSDE.

Using EM I looked at the DBMP node. It's empty. I looked at the Jobs node and it's empty too.

I did have a DBMP scheduled at one time but I deleted it because of the problem I described in my first message.

And yet, according to the Event Log and the SQL Server Log a backup has been successfully taking place every morning at the exact time I told it to start.

The problem though is it's successfully backing up to some non-existent virtual device. Since the device doesn't seem to exist I can't access it and therefore I have no backups. :(

I hope you have fun with this one Kyle. ;)