CMS Snapshot Analysis - Run Analyzer - Fatal Error - SQL Server TSQL with Core CAST AIP - KB Name Knowledge Base trunc. log on chkpt option value is currently OFF

Following error is encountered during T-SQL analysis

'<KB Name>' Knowledge Base 'trunc. log on chkpt.' option value is currently OFF.
Database option 'trunc. log on chkpt.' should be turned ON before proceeding (please run 'sp_dboption').
'dbname' database synchronization terminated with following error code : SYNC-4993.3987.

This option need to be set for the SQL Server Knowledge base. In fact This option helps ensure that the transaction log of the database does not fill up, and prevents problems that may occur due to missing log space in the database.

To resolve this issue you need to set the value of 'trunc. log on chkpt.' option value of Kb to ON.

1. Run the below queries on the knowledge base: * Replace <KB Name> with the KB Name

    Check if trunc. log on chkpt is set:        
           sp_dboption     
          '<KB Name>'
           go

    set the parameter
          use master
          go
         EXEC
           sp_dboption '<KB Name>, 'trunc. log on chkpt', 'true'
           go
           sp_dboption 
        '<KB Name>
           go

    restart SQL Server Agent
           net stop SQLServerAgent
           net start SQLServerAgent

2. Now run the analysis