Post reply

Moved CDC enabled database to another server and lost CDC

  • July 9, 2016 at 8:05 am

    #311576

    Hello

    I had 2 cdc SQL Server 2012 SP3 instances, and needed to move few databases from one server to the other, when I did it the cdc objects remained there but when I run:

    SELECT name, database_id, is_cdc_enabled FROM sys.databases

    WHERE name = 'MYDB' it says that it is not enable,

    what can I do as to recover/fix?

    Thanks in advance

  • July 9, 2016 at 2:28 pm

    #1889317

    restore needs to be done using option keep_cdc.

    you now either need to do the restore again and apply any new transaction to that db if required or you can enable cdc now on the new db and set all required tables to be under cdc - but on this last case you loose the set of changes done since the restore and will need to deal with those manually

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

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