search cancel

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.