Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to: Defect Multiple Target Servers from a Master Server (SQL Server Management Studio)
Collapse the table of content
Expand the table of content

How to: Defect Multiple Target Servers from a Master Server (SQL Server Management Studio)

This topic describes how to defect multiple target servers from a multiserver administration configuration. Run this procedure from the master server.

To defect multiple target servers from a master server

  1. In Object Explorer, expand a server that is configured as a master server.

  2. Right-click SQL Server Agent, point to Multi Server Administration, and then click Manage Target Servers.

  3. Click Post Instructions, and then in the Instruction type list, select Defect.

  4. Under Recipients, do one of the following:

    • Click All target servers to defect all target servers of this master server. Use this option if you want to completely uninstall the current multiserver administration configuration.

    • Click These target servers, and then click the corresponding Select box, to defect some, but not all, target servers of this master server.

Community Additions

ADD
Show:
© 2015 Microsoft