ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
The db recovery model changes on a regular basis
book
Article ID: 213698
calendar_today
Updated On:
Products
Clarity PPM On Premise
Issue/Introduction
The SQL Server ppm_dwh database recovery model is changing from SIMPLE to BULK_LOGGED and back throughout the day. What process would cause that behavior?
Environment
Component : CA PPM DATA WAREHOUSE
Resolution
As part of the Load Data Warehouse job, the recovery mode is changed to BULK_LOGGED. Once completed, it will set back to SIMPLE again.