Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MSX - How do I get rid of the master? Expand / Collapse
Author
Message
Posted Wednesday, July 23, 2008 7:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 17, 2010 7:42 AM
Points: 80, Visits: 167
Hi

I have a server that is currently mistakenly setup as a master MSX server. I cant for the life of me figure out how to remove it as an MSX master?

Thanks
Post #539220
Posted Wednesday, July 23, 2008 7:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 17, 2010 7:42 AM
Points: 80, Visits: 167
Figured it out. If you remove all target servers MSX Master is removed

I used sp_delete_targetserver
Post #539250
Posted Friday, November 29, 2013 3:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 9:32 AM
Points: 8, Visits: 125
Hi there, do you know if a target is in Normal suspected offline mode (status=3), and not downloading any changes from master, what could be the reason?

What I have found so far is, when you push a job that runs against a certain database that doesn’t exist on the target and that’s when you find the server is blocked. But this is not the case on my side.

Any ideas how to figure it out?

Many thanks
Post #1518496
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse