search cancel

MS SQL Dataware house Database Recovery Model keeps changing into Bulk-logged setting

book

Article ID: 188828

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

As soon as MS SQL Dataware Recovery Model  is set to Full Load Dataware house Job fails and during the job run the Recovery model is set to Bulk Logged

Environment

All Clarity Supported Release 

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
  • Setting the full recovery model will fail the DWH