Views:

Error Log

Upon further analysis, there is an error log seen on the Windows event viewer of the Policy Server indicating a database disk space error upon executing the stored procedure:

Error

Solution

  1. Ensure that you have privileges to access the Policy Server and/or Policy Server Database (SQL Server).
  2. Open the SQL Server Management Studio (SSMS) then connect to the database of the policy server.
  3. Download and open the stored procedure to purge the Audit log using SSMS: sp_PurgeAuditLog.sql
  4. Type the below command to run the sp_PurgeAuditLog.sql (For example: "EXEC dbo.PurgeAuditLog 30")

    Run command

     
    Please make sure of how many days you want to keep the logs.
     
  5. Enable the purge function in the MMC.

    Policy Server MMC