Unable to open maintenance plan in SQL 2005 after upgrade…
You may experience trouble to work with mainteaince plan after SP or hotfix upgrade on SQL 2005 failover cluster on Windows 20008. Whenever you attempt even to open an mainteaince plan or create a mainteaince plan, SQL server throws error below error:
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
However the jobs from the mainteaince plan keeps working.
If you experience this situation, this actually indicates a known problem where upgrade installer failed to update resource database and other system database. This issue occers because the nodes within the cluster have computer names that have all lowercase characters or that have mixed case characters.
To resolve this situation, please follow below steps:
Step 1: Confirm that the nodes within the cluster have computer names that have all lowercase characters or that have mixed case characters. Also verify that the build version of resource database is different (outdated) compared to the build version of SQL instance. You can use below code to find version of resource database:
Note: To know more about resource database, please refer to http://blog.consultdba.com/2010/03/note-on-resource-database.html
Step 2: Once all the findings of Step 1 are confirmed as explained above, apply Sp3 CU9 to resolve this issue. Please refer to http://support.microsoft.com/kb/980176/en-us to view more about this hotfix and to download the executables.
Note: This hotfix installation will require a restart. So be prepared accordingly when you are working on a production instance.