[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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,166 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,414 questions
Microsoft Configuration Manager
{count} votes

1 answer

Sort by: Most helpful
  1. LiHongMSFT-4306 29,276 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 Answers by the question author, which helps users to know the answer solved the author's problem.