SubscriptionSyncInfo table in Online Scenario

(0) Share

Report

Posted on by Peter Gruendler

136

I have an issue in an Online Scenario where the SubscritptionSyncInfo has grown to 2,7 GB. I have querried this table with XRM Toolbox and saw that it contains synchronization time stamps mostly from users who do not exist in the organization anymore. Actually the Customer pays for these 2,7 GBs per month but there is no given way for him to minimize the used storage size of the dbo.SubscriptionSyncInfo. Even the MS Support says there is no supported way how to delete old records of this table.

Is there a way to reduce the used storage amount of this table in Online Scenarios or for deleting these record by supported methods?

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Peter Gruendler 136 on at

Like (0)

Report

RE: SubscriptionSyncInfo table in Online Scenario

Issue has been solved through the MS product team. There were over 23 million of subscriptionsyncinfo records which needed to be deleted but the Deletion Service couldn't handle at the end. The product team did run a SQL Script which deleted these records from expired subscriptions.