microsoft dynamics rms reduce database size

*If not calling from a SQL job, use the WAITFOR > DELAY '00:00:02.000'Ģ. Wlb.AsyncOperationId = dart.AsyncOperationIdĭelete WorkflowLogBase from WorkflowLogBase W, dĭelete BulkDeleteFailureBase From BulkDeleteFailureBase B, dĭelete BulkDeleteOperationBase From BulkDeleteOperationBase O, dĭelete WorkflowWaitSubscriptionBase from WorkflowWaitSubscriptionBase WS, dĭelete AsyncOperationBase From AsyncOperationBase A, d Select = poa from PrincipalObjectAccess poa Insert into top AsyncOperationId from AsyncOperationBase (,)ĭeclare table (AsyncOperationId uniqueidentifier not null primary key) WHERE name = N'CRM_AsyncOperation_CleanupCompleted')ĭROP Index AsyncOperationBase.CRM_AsyncOperation_CleanupCompletedĬREATE NONCLUSTERED INDEX CRM_AsyncOperation_CleanupCompleted

Execute the following SQL statement to remove redundant records from the AsyncOperationBase table: You should leave the PrincipleObjectBase table alone as this deals with many aspects of record access, sharing etc.ġ. Disk space can be a premium in these environments, thus having the ability to trim down the CRM database can be very useful. The problems typically occur in QA, UAT or DEV environments where you need to restore a prod like copy in order to work against real life data. The size of the CRM database shouldn't be an issue within your production environment, as adequate space should be provisioned for this growth. There are several tables within each CRM Organization database that can become very large.

Microsoft dynamics rms reduce database size