Post reply

CDC is not working after renaming the database

  • June 22, 2012 at 12:55 am

    #276830

    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.

  • June 22, 2012 at 4:35 am

    #1504414

    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.

  • June 22, 2012 at 4:41 am

    #1504416

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

    I do not want to loss the data.

  • June 22, 2012 at 4:55 am

    #1504420

    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.

  • June 22, 2012 at 5:02 am

    #1504424

    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