Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

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 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...