search cancel

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


Article ID: 188828


Updated On:


Clarity PPM On Premise


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


All Clarity Supported Release 


  • 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