locked
Change tracking setting on RD Broker Database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    I am a noob on the Remote desktop services. We have an issue where backups are not happening on the server and

     DISK = N'\\\\usb-ss..." failed with the following error: "Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'.
    Failed to flush the commit table

    When I searched on the internet, I see some are suggesting to turn off the Change tracking and Turn it on back.

    Should the Change tracking be ON on the Database ?

    Is it safe to turn it OFF and turn it ON later to see that fixes the issue ?

    Thanks and Regards,

    A

    Friday, October 16, 2015 3:22 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    When I searched on the internet, I see some are suggesting to turn off the Change tracking and Turn it on back.

    Should the Change tracking be ON on the Database ?

    Is it safe to turn it OFF and turn it ON later to see that fixes the issue ?

    Hi,

    Based on my research, Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications.

    I don't think that it would hurt to disable it for a while.

    More information for you:

    Change Tracking

    https://technet.microsoft.com/en-us/library/cc280462(v=sql.105).aspx

    About Change Tracking (SQL Server)

    https://technet.microsoft.com/en-us/library/bb933875(v=sql.110).aspx

    Best Regards,

    Amy 

    Please remember to mark the replies as answers if they help and un-mark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by Amy Wang_ Monday, November 9, 2015 3:39 PM
    • Marked as answer by Amy Wang_ Monday, November 9, 2015 3:39 PM
    Wednesday, October 21, 2015 4:15 PM