| title | Administer Multiple Servers Using Central Management Servers | Microsoft Docs | ||||||
|---|---|---|---|---|---|---|---|
| ms.custom | |||||||
| ms.date | 06/13/2017 | ||||||
| ms.prod | sql-server-2014 | ||||||
| ms.reviewer | |||||||
| ms.technology | supportability | ||||||
| ms.topic | conceptual | ||||||
| helpviewer_keywords |
|
||||||
| ms.assetid | 427911a7-57d4-4542-8846-47c3267a5d9c | ||||||
| author | MashaMSFT | ||||||
| ms.author | mathoma | ||||||
| manager | craigg |
You can administer multiple servers by designating Central Management Servers and creating server groups.
An instance of [!INCLUDEssNoVersion] that is designated as a Central Management Server maintains server groups that contain the connection information for one or more instances of [!INCLUDEssNoVersion]. [!INCLUDEtsql] statements and Policy-Based Management policies can be executed at the same time against server groups. You can also view the [!INCLUDEssNoVersion] log files on instances that are managed through a Central Management Server. Versions of [!INCLUDEssNoVersion] that are earlier than [!INCLUDEssKatmai] cannot be designated as a Central Management Server.
[!INCLUDEtsql] statements can also be executed against local server groups in Registered Servers.
To create a Central Management Server and server groups, use the Registered Servers window in [!INCLUDEssManStudioFull]. Note that the Central Management Server cannot be a member of a group that it maintains. For more information about how to create Central Management Servers and server groups, see Create a Central Management Server and Server Group (SQL Server Management Studio).