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

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,012 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,245 questions
Microsoft Configuration Manager
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 28,121 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".

    0 comments

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.