The Cachebuilder service frequently switches the ServiceManagement database recovery mode between "FULL" and "BULK_LOGGED". Currently, this behavior is by design, but will be changed in a future release. If you would like to change this behavior now, follow the steps below:
- Open SQL Server Management Studio.
- Expand the ServiceManagement database node.
- Expand Programmability then Stored Procedures.
- Right-click the spUpdate_ToggleRecoveryModeBulkLogged stored procedure and select "Modify."
- In the ALTER PROCEDURE window, change the stored procedure to match the code below:
- Click the Execute button.
- You can now change the database recovery mode to Full, Bulk_Logged, or Simple.