Maintenance Plan Wizard (Select Target Servers Page)

  • Article

Use the Select Target Servers page to select the servers where you want to run the maintenance plan. This page is only visible on SQL Server instances that are configured as master servers.

To create a multiserver maintenance plan, a multiserver environment containing one master server and one or more target servers must be configured, and the local server should be configured as a master server. In multiserver environments, this page displays the (local) master server and all corresponding target servers.

To create or manage maintenance plans in a multiserver environment, additional configuration is required. For more information, see Maintenance Plans and Automating Administration Across an Enterprise.

See Also

Other Resources

Maintenance Plan Wizard
Creating a Multiserver Environment
How to: Make a Master Server (SQL Server Management Studio)
How to: Make a Target Server (SQL Server Management Studio)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

12 December 2006
New content:
  • Added description for multiserver maintenance plan support, which is available in SQL Server 2005 Service Pack 2 (SP2).