Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Master/Targer (MSX/TSX): Some TSXs are "Blocked"

Status
Not open for further replies.

soy4soy

IS-IT--Management
May 22, 2000
100
US
I have about 50 some odd MSSQL 7.0 servers distributed throughout the nation.

All of them are Target SQL Servers (TSX) to my Master Server (MSX) here in my corporate office.

The MSX server has holds the scripts that get distributed to all of my TSX servers... in theory.

Over time, most of the TSXs have become "Blocked" and will not take their new scripts from the MSX. Only about 5 or 6 are still left uncorrupted and I cannot find a common thread that makes them special.

Any ideas on how to make my TSXs take their medicine??

Thanks
 
Short of taking down the server, re-installing SQL, and re-joining the MSX, is there anything I can do here?

Would anyone like to have more information?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top