Management DW job errors

After rebuilding master on several SQL 2008 clustered instances, I get problems with the data collection to MDW. We had to rebuild to change collation due to this setup bug. (argh!)

After the rebuild the following jobs fail.





It happens consistently over 3 instances in the same cluster, with different errors. I am looking fo se if any of you are MDW gurus and can explain to me what happens to it during master rebuild? And how do I uninstall it? That is my next step, to reistall, but I can 't find how to uninstall it first :-(

more ▼

asked Jan 12 '10 at 08:33 AM in Default

Steinar gravatar image

1.7k 3 4 6

(comments are locked)
10|1200 characters needed characters left

2 answers: sort oldest

I had some trouble with MDW before, but after a recommendation from some guys here I installed a cumulative update (I think it was CU5). If you already have CU5, try to reinstall it and see what happens.

more ▼

answered Jan 20 '10 at 11:13 AM

Håkan Winther gravatar image

Håkan Winther
15.5k 33 37 48

Thanks, I will try that at the next service window
Jan 25 '10 at 08:52 AM Steinar
(comments are locked)
10|1200 characters needed characters left

Bumping this up in case anybody wants to give it a go :-)

more ▼

answered Jan 19 '10 at 11:09 AM

Steinar gravatar image

1.7k 3 4 6

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 12 '10 at 08:33 AM

Seen: 3854 times

Last Updated: Jan 12 '10 at 10:43 AM