x
login about faq Site discussion (meta-askssc)

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.

Collection_set_2_collection

Collection_set_2_upload

Collection_set_3_collection

Collection_set_3_upload

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

Steinar
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
15k 29 35 46

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

Steinar
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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1601
x82
x67

asked: Jan 12 '10 at 08:33 AM

Seen: 1602 times

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

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.