x

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, 2010 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 voted first

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, 2010 at 11:13 AM

Håkan Winther gravatar image

Håkan Winther
15.6k 35 37 48

Thanks, I will try that at the next service window
Jan 25, 2010 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, 2010 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.

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1842
x86
x76

asked: Jan 12, 2010 at 08:33 AM

Seen: 4419 times

Last Updated: Jan 12, 2010 at 10:43 AM