Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server 2008 R2 SP3 - Restore problem for CDC e

Author  Topic 

jimmyntio
Starting Member

1 Post

Posted - 2014-10-20 : 23:09:59
Hi,

I am just wondering whether anyone has run into a problem in restoring database backup from of SQL Server 2008 R2 Enterprise SP3 with the CDC turned on into SQL Server 2008 R2 SP3 Standard Edition?

Below error message appears despite the database restore script does NOT include keep_cdc flag.

SQL Server cannot load database '%' because Change Data Capture is enabled. The currently installed edition of SQL Server does not support Change Data Capture.

This was not an issue on SQL Server 2008 R2 SP2. Could this be a new bug?

Thank you.
   

- Advertisement -