SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Database Engine
Database Engine How-to Topics
Automated Administration How-to Topics (SQL Server Management Studio)
How to: Set the Service Startup Account for SQL Server Agent (SQL Server Configuration Manager)
How to: Restart the SQL Server Agent Service (SQL Server Management Studio)
How to: Set the Mail Profile for SQL Server Agent (SQL Server Management Studio)
How to: Set the SQL Server Connection (SQL Server Management Studio)
How to: Set a SQL Server Alias (SQL Server Management Studio)
How to: Configure a User to Create and Manage SQL Server Agent Jobs (SQL Server Management Studio)
How to: Create a Job (SQL Server Management Studio)
How to: Disable a Job (SQL Server Management Studio)
How to: Create a Job Category (SQL Server Management Studio)
How to: Delete a Job Category (SQL Server Management Studio)
How to: Assign a Job to a Job Category (SQL Server Management Studio)
How to: Change the Membership of a Job Category (SQL Server Management Studio)
How to: Give Others Ownership of a Job (SQL Server Management Studio)
How to: Create a CmdExec Job Step (SQL Server Management Studio)
How to: Create a Transact-SQL Job Step (SQL Server Management Studio)
How to: Define Transact-SQL Job Step Options (SQL Server Management Studio)
How to: Create an ActiveX Script Job Step (SQL Server Management Studio)
How to: Create an Analysis Services Job Step (SQL Server Management Studio)
How to: Set Job Step Success or Failure Flow (SQL Server Management Studio)
How to: View Job Step Information (SQL Server Management Studio)
How to: Set Up the Job History Log (SQL Server Management Studio)
How to: View the Job History (SQL Server Management Studio)
How to: Make a Master Server (SQL Server Management Studio)
How to: Make a Target Server (SQL Server Management Studio)
How to: Enlist a Target Server to a Master Server (SQL Server Management Studio)
How to: Defect a Target Server from a Master Server (SQL Server Management Studio)
How to: Defect Multiple Target Servers from a Master Server (SQL Server Management Studio)
How to: Schedule a Job (SQL Server Management Studio)
How to: Set CPU Idle Time and Duration (SQL Server Management Studio)
How to: Notify an Operator of Job Status (SQL Server Management Studio)
How to: Write the Job Status to the Windows Application Log (SQL Server Management Studio)
How to: Automatically Delete a Job (SQL Server Management Studio)
How to: Set the Polling Interval for Target Servers (SQL Server Management Studio)
How to: Start a Job (SQL Server Management Studio)
How to: Stop a Job (SQL Server Management Studio)
How to: View Job Activity (SQL Server Management Studio)
How to: Force a Target Server to Poll the Master Server (SQL Server Management Studio)
How to: View a Job (SQL Server Management Studio)
How to: Resize the Job History Log (SQL Server Management Studio)
How to: Clear the Job History Log (SQL Server Management Studio)
How to: Modify a Job (SQL Server Management Studio)
How to: Modify the Target Servers for a Job (SQL Server Management Studio)
How to: Specify a Target Server's Location (SQL Server Management Studio)
How to: Delete Jobs (SQL Server Management Studio)
How to: Synchronize Target Server Clocks (SQL Server Management Studio)
How to: Script Jobs Using Transact-SQL (SQL Server Management Studio)
How to: Create an Operator (SQL Server Management Studio)
How to: Assign Alerts to an Operator (SQL Server Management Studio)
How to: Format Pager Addresses (SQL Server Management Studio)
How to: Designate a Fail-Safe Operator (SQL Server Management Studio)
How to: Create an Alert Using an Error Number (SQL Server Management Studio)
How to: Create an Alert Using Severity Level (SQL Server Management Studio)
How to: Create a WMI Event Alert (SQL Server Management Studio)
How to: Define the Response to an Alert (SQL Server Management Studio)
How to: Disable or Reactivate an Alert (SQL Server Management Studio)
How to: Designate an Events Forwarding Server (SQL Server Management Studio)
How to: View Information About an Operator (SQL Server Management Studio)
How to: Edit an Operator (SQL Server Management Studio)
How to: Change an Operator's Availability (SQL Server Management Studio)
How to: Delete an Operator (SQL Server Management Studio)
How to: View Information about an Alert (SQL Server Management Studio)
How to: Edit an Alert (SQL Server Management Studio)
How to: Delete an Alert (SQL Server Management Studio)
How to: Script Operators Using Transact-SQL (SQL Server Management Studio)
How to: Script Alerts Using Transact-SQL (SQL Server Management Studio)
How to: Set Job Execution Shutdown (SQL Server Management Studio)
How to: Autostart SQL Server Agent (SQL Server Management Studio)
How to: Send SQL Server Agent Error Messages (SQL Server Management Studio)
How to: View SQL Server Agent Error Log (SQL Server Management Studio)
How to: Rename a SQL Server Agent Error Log (SQL Server Management Studio)
How to: Write Execution Trace Messages to the SQL Server Agent Error Log (SQL Server Management Studio)
How to: Create a Proxy (SQL Server Management Studio)
How to: Modify a Proxy (SQL Server Management Studio)
How to: Delete a Proxy (SQL Server Management Studio)
How to: Script a Proxy Using Transact-SQL (SQL Server Management Studio)
Expand Minimize
This topic has not yet been rated - Rate this topic

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

SQL Server 2005

This topic describes how to defect a target server from a master server. Run this procedure from the target server.

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

  2. Right-click SQL Server Agent, point to Multi Server Administration, and then click Defect.

  3. Click Yes to confirm that you want to defect this target server from a master server.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.