I have a database with 3000 tables, all of them captured for CDC for compliance reasons. Now I'm restoring it, but I'm worried by the time the restore (with KEEP_CDC) is taking, and checked also the huge transaction log size the restore is generating.
While the restore is in progress, I'm making a trace and I cannot understand why the engine internally seems to just recreate the CDC schema (ie, creating all the CDC's procedures and functions for each table, and creating indexes/primary keys for all the tables).
Sorry for my ignorance, but why is re-creating the CDC environment this way? all the physical structures (tables and indexes) are in the backup, right? if so, why the need to recreate them on restore?
am I wrong?