Delete manually delete data

I have a serious problem with one of my production bases.

The database was included to collect change data, which performed reasonably well. Last month we had a server crisis where several disks were damaged and data was lost. We then restore the database backups from tapes and restore them to the newly installed database server.

The problem I am currently facing is the following:

  • sys.database

    indicates that my database is not enabled for cdc
  • the database contains the schema cdc, user, tables, sp and functions.
  • sys.sp_cdc_enable_db

    throws an error stating that the schema and custom "cdc" already exist, so they cannot create them and enable the database for cdc
  • sys.sp_cdc_disable_db

    will not remove the remnants of the cdc as it believes the database is not enabled for the cdc
  • leftovers from the cdc cannot be manually deleted as they are all stored procedures and system functions.

So now I am stuck in a database that cannot be enabled for cdc since it already has all the cdc components and cdc cannot be disabled since it is not signaled in sys.database that cdc is enabled.

Is there any solution for my problems, execpt to create a new database and transfer the entire object (except cdc) and data to the new database?

+2
sql sql-server sql-server-2008 change-data-capture


source to share


No one has answered this question yet

Check out similar questions:

1170
How do I remove duplicate lines?
560
What's the best way to automatically generate INSERT statements for a SQL Server table?
4
CDC crashes after connecting a database to an instance of SQL Server 2008 R2
2
SQL Server 2012 Modified data collection error 14234
2
Change Data Capture - initial download of historical data
1
How to change or condition the retention period for CDC (SQL Server 2012)
1
Data Capture Change (CDC)
1
SQL Server 2008 CDC unresponsive and stuck after table dropped
0
Data Cleanup Job (CDC) only deletes multiple records at a time
0
Sp_cdc_enable_db_internal routine, line 49 Database "Database name" cannot be enabled to modify data collection



All Articles
Loading...
X
Show
Funny
Dev
Pics