THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Resynchronizing a target server (MSX - TSX)

I often use SQL Server Agent master / target servers (MSX/TSX). I find it so convenient to create the job once and then just add whatever targetservers (TSX) should have this job. Especially when you later modify the job. Again, just modify it once. The usage of MSX in general, and how I use it, can easily become a series of blog posts in itself. But that is not the point here.

Sometimes a TSX goes out-of-sync with its master. I've never understood exactly under what circumstances, but it feels like it happened when you do things "too quickly". Like change a job, push it out, and before the push has finished, you change it again. Or something like that. A TSX going out-of-sync doesn't happen frequently. I've had it a handful of times. And every time, I have spent time searching etc. on how to fix it.

A couple of days ago, a client of mine had this case, and he had himself tracked down a possible way to fix this. We decided to go ahead with this, and it worked just fine. So, the purpose here is to document the (very easy) fix, for whenever this happens again. And for all of you out there who might benefit, of course. The error you see is something like:

[291] An unresolved problem exists with the download instructions (sysdownloadlist) for target server 'Y' at MSX 'X'

X here is obviously the master and Y the target. And the solution was quite simply (in the msdb database):

EXEC dbo.sp_resync_targetserver, N'Y'

Are you using MSX/TSX? Have you had sync issues? How did you handle them?

Published Sunday, August 11, 2013 12:59 PM by TiborKaraszi
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

David Korzennik said:

Hi Tibor

I have a large MSX/TSX setup. 176 Target servers.  All but one is working fine.  On this one server I was getting the unable to read or write to TSXCache.bin error. Found no solutions to that problem. I fixed the problem by going to MultiServer Admin, selecting the target server, finding the 1st download instruction that failed and deleting that.  I had to do that a few times.  Once the end of the list was reached for download instructions for the server, instructions flowed again.

September 6, 2013 3:16 AM
 

TiborKaraszi said:

Hi David,

Thanks for the feedback! That is a lot of target servers. I have max had about 50, or so. Good to know that it is more or less running fine and also to have yet another thing to try in case a TSX acts up on you. :-)

September 7, 2013 1:28 PM
 

Faran said:

Hi Tibor, David

My target server is not downloading the instructions from master. target's status is 'Normal, Suspected offline'. I can't figure out whats wrong.

I have registered the target on master server and forced the poll, which says Poll successful, but simply the changed are not applied on target.

Any advice?

cheers

F

November 29, 2013 7:05 AM
 

Adam S said:

Some background I have 3 environments running about 40 servers each and every so often we have a few servers going suspect or blocking. This little gem of a script helped me fix those 5-6 servers when they do decide to go off the deep end.

Thanks for the script and information.

February 20, 2014 1:25 PM

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement