Restoring CDC Enabled DB from a Microsoft DPM backup server RRS feed

  • Question

  • Below is the text and link to some documentation that says i should be able to reattach a database that was CDC enabled to another server, and CDC will stay enabled. We are using DPM server as our backup solution, and found out that the only way to restore and keep any CDC information was to do a network file restore, and then manually attach the DB files to the new server(since there is no Keep_CDC flag available in DPM) This does keep the CDC data and it is all still query-able when the db is attached to another server. BUT the Database itself has the flag is_cdc_enabled set to 0... and there is no way to get that back to an enabled state, without losing ALL of the existing CDC data?

    T Beaucage

    Friday, September 5, 2014 1:17 PM