PART 3

Administering Microsoft SQL Server 2012

C H A P T E R  6

Multi-Server Administration

With the number of database servers increasing and the tolerance for errors decreasing in today’s organizations, it is has become necessary to define and maintain database standards across the enterprise. One of the problems in the past has been making sure those standards are being followed. As a DBA, you would have to go out to each server and run queries using system tables to ensure that each server was in compliance. Luckily, you can now use Policy-Based Management to ensure that your standards are being followed. In addition, by using central management servers, you can use a single server as an access point to all the servers in the organization. ...

Get Pro SQL Server 2012 Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.