| title | Maintenance Plan (Servers) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 06/13/2017 | ||
| ms.prod | sql-server-2014 | ||
| ms.reviewer | |||
| ms.technology | supportability | ||
| ms.topic | conceptual | ||
| f1_keywords |
|
||
| ms.assetid | ac24d1a8-dd2f-4162-b804-c0df1fc1e61d | ||
| author | MikeRayMSFT | ||
| ms.author | mikeray | ||
| manager | craigg |
Use the Servers dialog box to select the servers where you want to run the maintenance plan.
A multiserver environment containing one master server and one or more target servers must be configured to create a multiserver maintenance plan. For multiserver maintenance plans, the local server should be configured as a master server. In multiserver environments, this dialog box displays the (local) master server and all corresponding target servers. One [!INCLUDEssNoVersion] Agent job is created for the local server. It is enabled or disabled depending on whether you select the (local) server. If target servers are selected, a multiserver job is created and downloaded to each of the selected target servers. If no target servers are selected, the multiserver job is deleted.
Maintenance Plans
Create a Multiserver Environment
Make a Master Server
Make a Target Server