MS SQL Dataware house Database Recovery Model keeps changing into Bulk-logged setting
Article ID: 188828
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