New answers tagged change-data-capture
If you are restoring a CDC-enabled database onto a different instance, you must ensure the server principal that "owns" the database in question is present on the target instance prior to performing the restore. You must also ensure you use the KEEP_CDC option when restoring the database. From the MSDN page on restore options: KEEP_CDC should be used to ...
Top 50 recent answers are included