How to defect multiple target servers from a master server (Enterprise Manager)

How to Install SQL Server 2000

How To

How to defect multiple target servers from a master server (Enterprise Manager)

To defect multiple target servers from a master server

  1. Expand a server group, and then expand a server configured as a master server.

  2. Expand Management.

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

  4. Click Post Instructions, and then in the Instruction type list, click Defect.

  5. 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.