Database Reference
In-Depth Information
CMS is introduced in SQL Server 2008, as earlier versions of SQL Server cannot be
designated as a Central Management Server. The main characteristic of CMS is to execute
TSQL and Policy-based management policies at the same time against these designated
server groups.
How to do it...
To get started, we will need to complete the following steps to implement the central
management server feature to the existing SQL Server data platform:
1. SQL Server Management Studio is the main tool to designate the CMS feature. Open
SQL Server Management Studio, on the View menu, click Registered Servers.
2. In Registered Servers, expand Database Engine, right-click Central Management
Servers, point to New, and then click Central Management Servers.
3. In the New Server Registration dialog box, register the instance of SQL Server that
will be the central management server.
4. In Registered Servers, right-click the central management server, point to New, and
then click New Server Group. Type a group name and description, and then click OK.
5. In Registered Servers, right-click the central management server group, and then
click New Server Registration.
6.
In the New Server Registration dialog box, register one or more instances of SQL
Server that will be members of this server group, see the following screenshot:
 
Search WWH ::




Custom Search