Share via

[Completed with warning]:The site database has a backlog of SQL change tracking data. For more information

Mirza Anwarulla Baig 0 Reputation points
2024-11-10T09:06:45.25+00:00

We got this issue when we run prerequisites check in Configuration Manager (SCCM).error

[Completed with warning]:The site database has a backlog of SQL change tracking data. For more information

see https://go.microsoft.com/fwlink/?linkid=2027576

Microsoft Security | Intune | Configuration Manager | Other
Windows for business | Windows Server | User experience | Other
SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 31,616 Reputation points
    2024-11-11T02:21:51.2233333+00:00

    Hi @Mirza Anwarulla Baig

    [Completed with warning]: The site database has a backlog of SQL change tracking data.

    Check the auto cleanup status:

    SELECT * FROM sys.change_tracking_databases WHERE database_id=DB_ID('<database_name>')

    Review this doc for more detail steps: Troubleshoot change tracking auto cleanup issues.

    Besides, see if this article helps: SCCM-The site database has a backlog of SQL change tracking data.

    Best regards,

    Cosmog

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.