The automated administration of multiple SQL Server instances requires a pool of resources and multiple utilities to manage. Since SQL Server 2005 Service Pack 2 (SP2), the multiple instance management feature is introduced and using SQL Server agent services for the central administration of jobs. Managing multiple instances will increase the total cost of ownership (TCO) and software footprint. In this recipe, we will concentrate on the feature that will help in achieving automated administration across the data platform enterprise and manage multiple administrative scheduled jobs using Multiserver administration concepts.
To enable the Multiserver administration environment, we need more than one SQL Server instance that will stand as master server and target server. The Multiserver administration requires setup of a master server (MSX) and one or more target servers (TSX).
The Multiserver administration is possible between SQL...