CDC is not working after renaming the database

  • Hi All!

    I have renamed the database on which CDC was enabled. After renaming, the CDC is not capturing the data into the capture instance table.

    Please suggest.

  • Have you tried disabling CDC and then re-enabling it?

    You may also have to restart the services, but I'd try the above suggestion first. Chances are CDC is still looking for the old database name.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Disabling and re-enabling the CDC will leads to data loss in CDC capture instance table.

    I do not want to loss the data.

  • Its done!!!! 🙂

    What I did is after renaming the database, go to Job Activity Monitor and re-start the cdc capture job of the database. It will start capturing the changes.

  • Glad it worked out for you.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 5 posts - 1 through 4 (of 4 total)

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