November 19, 2003 at 7:05 am
Our shop makes heavy use of multi-server administration. Occaisionally, when viewing target server status from enterprise manager on the master server (SQL Server Agent > Multi-Server Administration > Manage Target Servers..), one or more target servers will have a status of "Blocked". We have discovered the stored proc sp_resync_targetserver which clears the problem (although it also removes job history data). However, I am trying to understand more about this blocked status. What does "blocked" actually mean? What causes it to occur? What methods are available to detect and correct the problem? etc. etc. Books on Line is pretty silent in this area with just a couple of terse references and no explaination.
Our environment is all SQL 2000 sp2 (with hotfixes),Win2000 sp3, 1 master server and 40 target servers. All target servers are in active/active 2 node clusters. Using TCP/IP.
Any insights would be greatly appreciated.
November 24, 2003 at 12:00 pm
This was removed by the editor as SPAM
June 10, 2014 at 7:57 am
just open "download instruction" and delete all failed instructions.
so blocked means that some instructions failed to apply
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply