can't select one db in maintenance plan?

[swhitten]

SQL 2005 User is reporting that in Mgmt Studio, he cannot select one of his databases when he tries to configure a maintenance plan. He says all the others can be selected but not this one.

I'm heading out there this morning to look for myself, but I've never seen this. Any ideas?

Thanks!

 

[JayKusch]

Was the DB Offline or set as a log shipped DB?

Just wondering

Thanks

J. Kusch

 

[swhitten]

I'm back from client's office. I had no issue selecting the db, so I'm not sure what he was seeing. Maintenance plan was returning consistency errors for several of the dbs. So I ran dbcc updateusage, and that resolved the consistency errors. These were upgraded from SQL 2000, and I'm sure that had never been run.

Thanks!