none
PROCEDURE pub.MSP_WEB_SP_SEC_PSMODE_PERM_SYNC_DeleteAllOldPermissionStates filled 200 GB in log database RRS feed

  • Question

  • Hello 

    I have a Project Server 2013 with SQL Server 2014 environment and lately the ProjectWebApp database grows up to 200 GB every night. Reviewing I found that PROCEDURE pub.MSP_WEB_SP_SEC_PSMODE_PERM_SYNC_DeleteAllOldPermissionStates is the culprit. We currently have more than 2000 projects and more than 1000 users (active and inactive) in Project Server but I do not find it normal for the log to grow so much.
    Additionally, database recovery model was changed to Simple and the growth of the log was the same.
    I appreciate if someone can guide me to understand why this happens.

    Thanks

    Wednesday, October 17, 2018 5:31 PM