Sample Policy Templates

SQL Server 2012 includes a plethora of predefined sample policies, which can be leveraged by importing them into a SQL Server 2012 system. The policies available for import are located in the default installation drive, which is usually located at C:\Program Files\Microsoft SQL Server\110\Tools\Policies\DatabaseEngine\1033 (or C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Policies\DatabaseEngine\1033 if you are running in a 64-bit environment). As mentioned earlier, you can import the desired policies by right-clicking the Policies node and selecting Import. The sample templates are categorized by SQL Server feature such as Database Engine, Reporting Services, and Analysis Services.

Get Microsoft® SQL Server 2012 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.