Implementing Surface Area Configuration Checks
SQL Server 2005 shipped with the SQL Server Surface Area Configuration (SAC) tool. This tool allowed you to enable or disable various components and services on individual SQL 2005 Servers. This feature was deprecated in SQL Server 2008 because the Microsoft team felt that the better way to handle these configuration tasks was through Policy-Based Management.
If you want to implement the Surface Area Configuration feature in SQL Server 2008 to configure components and services, import the following policies:
• Surface Area Configuration for Database Engine 2005 and 2000 Features.xml
• Surface Area Configuration for Database Engine 2008 Features.xml
• Surface Area Configuration for Service Broker ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
