Policy-Based Management Storage
Applies to: 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).
Storing Policies
SQL Server includes policies that can be used to monitor an instance of SQL Server. By default, these policies are not installed on the Database Engine. 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 Database Engine.
Policy history for policies evaluated in the current instance of the Database Engine is maintained in msdb system tables. Policy history for policies applied to other instances of the Database Engine or applied to Reporting Services or Analysis Services is not retained.
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho