locked
Jobs Not Created After Enabling CDC RRS feed

  • Question

  • Hi,

    I need your help in process of CDC.

    The problem is:

    I have a CDC Enabled Database CDCDB on Server A. Now i will Take a Backup of this CDCDB from Server A and Restore it On to Server B as CDCDB. When i check is CDC Enabled after Restoration i get it as Yes but my Queries are:

    A. Will the CDC be actually Enabled or Do i need to Disable and Enable the same.

    B. Why arent the JOBS Related to CDC are not  getting created After Restoration Process.

    Any help appreciated. Thanks


    Thanks & Regards, Manjunath C Bhat, http://manjunathcbhat.blogspot.com http://manjunathcbhat.wordpress.com
    Tuesday, July 27, 2010 7:07 PM

Answers

All replies

  •  

    Manjunath,

     

    You need to use KEEP_CDC argument while restoring the CDCDB on Server B.

     

    Ref:

    http://msdn.microsoft.com/en-us/library/ms178615.aspx


    http://SankarReddy.com/
    • Marked as answer by Tom Li - MSFT Thursday, August 5, 2010 2:50 AM
    Tuesday, July 27, 2010 9:42 PM
  • Please refer to the hyperlink that Sankar provided in his reply. You should find the message said,

    [Restoring the database with KEEP_CDC will not create the Change Data Capture jobs. To extract changes from the log after restoring the database, recreate the capture process job and the cleanup job for the restored database. For information, see sys.sp_cdc_add_job (Transact-SQL).]

    Good Luck

    Q

    • Marked as answer by Tom Li - MSFT Thursday, August 5, 2010 2:51 AM
    Tuesday, July 27, 2010 9:47 PM
  • Hi Guys,

    Thank you for the Information n sorry for late reply. sys.sp_cdc_add_job did help for me thank you.


    Thanks & Regards, Manjunath C Bhat, http://manjunathcbhat.blogspot.com http://manjunathcbhat.wordpress.com
    Friday, September 16, 2011 8:35 AM