| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
|---|---|---|---|---|---|---|---|---|---|
Policy-Based Management Storage |
Policy-Based Management Storage |
VanMSFT |
vanto |
08/09/2017 |
sql |
security |
conceptual |
|
[!INCLUDE SQL Server] Policies are stored in the msdb database. After a policy or condition is changed, msdb should be backed up. For more information, see Back Up and Restore of System Databases (SQL Server).
[!INCLUDEssnoversion] includes policies that can be used to monitor an instance of [!INCLUDEssNoVersion]. By default, these policies are not installed on the [!INCLUDEssDE]. However, you can import them from their default installation location. SQL Server Policies are stored in their respective version folder. For example, for SQL Server 2019, SQL Server Policies are stored in C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Policies\DatabaseEngine\1033.
You can directly create policies by using the File/New menu, and then saving them to a file. This enables you to create policies when you are not connected to an instance of the [!INCLUDEssDE].
Policy history for policies evaluated in the current instance of the [!INCLUDEssDE] is maintained in msdb system tables. Policy history for policies applied to other instances of the [!INCLUDEssDE] or applied to [!INCLUDEssRSnoversion] or [!INCLUDEssASnoversion] is not retained.