O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Automated administration across an enterprise

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.

Getting ready

To enable the Multiserver administration environment, we need ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required