Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Upgrading a production MS SQL Server from 2000 to 2005, the upgrade froze for a couple of hours. The process was killed and everything works except that we have no access to maintenance plans. When accessing them, we get:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click:


An exception occurred while executing a Transact-SQL statement or batch.     (Microsoft.SqlServer.ConnectionInfo)


Invalid object name 'msdb.dbo.sysmaintplan_plans'. (Microsoft SQL Server, Error: 208)

For help, click:     ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476



Comparing the msdb on the problem machine with other working 2005 installs, it looks like the msdb db did not get upgraded properly.

Before I take the server down, detach and rebuild the msdb per instructions I found here,, I wanted to see if anyone else had suggestions of what to look for or how to fix the msdb without downtime (this is a production system).


share|improve this question

As you interrupted the upgrade process god only knows what other parts didn't get completely upgraded. Have you reviewed the logs to see why the upgrade hung?

At this point I'd recommended that you burn the server and rebuild it from scratch. It's the only way to ensure that you don't run into strange problems later.

share|improve this answer
I'll look into the log again and see if I can dig anything out. The burning of the server is not really an option at the moment, but thanks! – user12153 Jul 8 '09 at 21:39

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.