.png)
How to: Defect Multiple Target Servers from a Master Server (SQL Server Management Studio)
SQL Server 2005
This topic describes how to defect multiple target servers from a multiserver administration configuration. Run this procedure from the master server.
-
In Object Explorer, expand a server that is configured as a master server.
-
Right-click SQL Server Agent, point to Multi Server Administration, and then click Manage Target Servers.
-
Click Post Instructions, and then in the Instruction type list, select Defect.
-
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.
-
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.
