tag:blogger.com,1999:blog-8792628637495446545.post9134164663553413692..comments2024-03-25T09:54:29.303-04:00Comments on Lucas Notes: Change Data Capture (CDC) and Simple Recovery ModeLucashttp://www.blogger.com/profile/14231394530002840714noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8792628637495446545.post-73265085924920333542016-08-22T22:19:29.583-04:002016-08-22T22:19:29.583-04:00It is an interesting question. Obviously, CDC is a...It is an interesting question. Obviously, CDC is available in Enterprise version of SQL Server (it is also available in Evaluation and Developer version of SQL Server). If we are looking to do log shipping and maintain CDC data to Standard Edition of secondary server, that would not work/ supported.<br /><br />But how about if we are looking to just do the log shipping without the CDC data? Supposedly according to Microsoft documentation (https://msdn.microsoft.com/en-us/library/cc645938.aspx#RestoreOrAttach), if we are to restore the database without the keep_cdc option, the CDC would be disabled. Technically, we could restore database without CDC to Standard Edition of SQL Server.<br /><br />But when I tested this out, unfortunately, it does not seems to work. I was able to restore the database with norecovery option just fine (I used Express Edition for testing). But whenever I tried to bring the database online using recovery option or standby option (to make it readable), I would get error message "SQL Server Cannot load database "xxx" because Change Data Capture is enabled. The currently installed edition of SQL Server does not support Change Data Capture. Either disable Change Data Capture in the database by using a supported edition of SQL Server, or upgrade the instance to one that supports Change Data Capture."<br /><br />The only way that I can bring it online is if I disable the CDC on the primary server using sys.sp_cdc_disable_db, do another transaction log on the primary server and then apply that one to the secondary instance and bring the database online on the secondary server. But that basically you eliminate CDC on the primary server as well.Lucashttps://www.blogger.com/profile/14231394530002840714noreply@blogger.comtag:blogger.com,1999:blog-8792628637495446545.post-11412451696619801182016-08-17T06:13:05.425-04:002016-08-17T06:13:05.425-04:00is it possible to implement log shipping on a data...is it possible to implement log shipping on a database with cdc enabled to a standard edition secondary server? thanks!Anonymousnoreply@blogger.com