Log shipping and CDC

  • Ells

    SSCrazy Eights

    Points: 9901

    I come seeking the wisdom of the collective. I have searched to no avail to try and understand the implication of using CDC on a database that uses log shipping. In a weird way I also want to understand if CDC will affect log shipping and vice versa.

    After much head scratching I am assuming that the truncation point in the log will move if CDC is deployed. So instead of the last commited transaction it will be the last commited transaction that has been harvested?

    So if I have log shipping every 10 minutes does this mean I need to get the CDC data out of my source system before that 10 minutes cut off. Will it make my log shipping out of date??

    So many questions. Pointers to good articles gratefully received.

    Many thanks

    :w00t:

  • Ells

    SSCrazy Eights

    Points: 9901

    Any suggestions?

    Thanks

    M

  • cfra066

    Newbie

    Points: 3

    Obviously this is a bit late to reply to this, but for future google searches...

    When you recover the database using the RECOVERY keyword, you should use the KEEP_CDC keyword in the restore command. This is only required in the last recovery restore, not the ongoing log restores.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply