Compliance Problems

Fix Retention Policies Limits for More Than 100 SharePoint Sites

Amos Gikunda Sep 28, 2026 869 views

Question details

The user needs to configure long-term retention for over 100 specific SharePoint sites and automatic deletion for all others, but is hindered by Microsoft Purview static scope limits.

How to Manage Retention Policies for More Than 100 SharePoint Sites

Product: Microsoft Purview
Device & OS: not provided
Scenario: Setting up long-term retention for selected sites and automatic deletion for all other sites where the number of excluded sites exceeds 100.
Observed behavior: Static scope limits prevent excluding all required sites in a single policy, and splitting exclusions across multiple policies causes unintended deletions due to overlapping rules.

Before you start

Before modifying organization-wide compliance settings, ensure you have Global Administrator or Compliance Administrator permissions in the Microsoft Purview portal.

Solution 1Recommended

Test Policy Overlaps on a Pilot SharePoint Site

Because overlapping retention and deletion policies can cause unexpected data loss when bypassing site limits, always run a controlled test on a single site before scaling up.

Splitting exclusions across multiple policies does not solve the site limit problem. A site excluded from a delete policy (Policy A) might still be processed and deleted by another policy (Policy B) if included in its scope.

Testing is critical because background retention timer jobs run on a weekly schedule, meaning overlapping delete policies might unexpectedly wipe data once a retention period expires.

Create a pilot site

Navigate to your SharePoint admin center and create a dedicated test SharePoint site specifically for compliance policy testing.

Configure the first policy

In the Microsoft Purview compliance portal, create a retention policy that retains content for one month, and then automatically deletes it.

Configure the second policy

Create a second retention policy that retains content for two months without any deletion action.

Apply and monitor

Apply both policies to the test site. Monitor the site for at least two months plus one week to observe how the background timer jobs handle the overlapping rules once the first retention period expires.

Test Policy Overlaps on a Pilot SharePoint Site

Timer Job Delays: Retention policies can take up to a week to apply, and actual deletion is performed by a weekly timer job. Factor this delay into your testing timeline.

Solution 2

Utilize Adaptive Scopes Instead of Static Scopes

If you are hitting the 100-site static scope limit, consider using adaptive scopes which do not have these strict per-policy numerical limits.

Free Microsoft Office alternative

Looking for a Lightweight Office Suite for Your Teams?

While Microsoft Purview handles complex backend compliance for SharePoint, your team still needs a reliable, fast, and highly compatible office suite for daily document creation. WPS Office provides a seamless, lightweight alternative to heavy desktop clients.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Lightweight installation that runs smoothly on older hardware and operating systemsFree to use with a familiar, easy-to-navigate tabbed interfaceBuilt-in PDF editing, conversion, and collaboration tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does splitting exclusions across multiple SharePoint retention policies fail?

When you split exclusions across multiple policies to bypass the 100-site limit, a site excluded from 'Delete Policy A' might still fall under the 'All Sites' scope of 'Delete Policy B'. Once a retention period expires, the overlapping delete policy will instruct the timer job to remove the content.

How long does it take for a SharePoint retention policy to apply?

Retention policies in Microsoft Purview can take up to a week to fully apply to SharePoint sites. Furthermore, the actual deletion of expired content is handled by a backend timer job that runs once a week.

What is the static scope limit for SharePoint sites in Microsoft Purview?

When using static scopes in Microsoft Purview retention policies, you are generally limited to explicitly including or excluding a maximum of 100 individual SharePoint sites per policy. Exceeding this limit requires either splitting policies or switching to adaptive scopes.

Microsoft Office Security Issues