search cancel

PPM_DWH Database Recovery Model keeps changing into Bulk-logged after update to Full

book

Article ID: 188828

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

We are having an issue with the Clarity PPM_DWH database, the MSSQL recovery model was set to full by our DBA but it keeps updating to bulk-logged. Is there a reason or a job that is doing this update?

Environment

CA PPM APPLICATION

Resolution

- The Data Warehouse job changes the SQL Server Recovery Model to accommodate bulk operations in the database, which helps performance of the load run by reducing the number of transactions being tracked.
- The Data Warehouse database is fully populated from Clarity database, the data can be re-created by running the DWH full job and full recovery model shouldn’t be a mandatory requirement.