question

jimmyntio avatar image
jimmyntio asked

SQL Server 2008 R2 SP3 - Restore problem for CDC enabled Backup

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.
restorecdc2008sp3r2
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
sp_lock avatar image
sp_lock answered
It is my understanding that you have to remove CDC from the source server (enterprise) before restoring on the destination (standard)
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jimmyntio avatar image jimmyntio commented ·
This is not the case when I have we are on SP2. According to the msdn docos, unless we use the flag keep_cdc, it will be restored without CDC, and this has been working fine since SP1 to SP2.
1 Like 1 ·
Mitesh.Shah avatar image
Mitesh.Shah answered
I am also experiencing the same
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.