SQL Server 2008 Change Data Capture Support

GrahamGoodwin · December 22, 2010 10:39AM

Does SQL backup support Change Data Capture when restoring databases? In SQL Server T-SQL when restoring a backup this is achieved via the KEEP_CDC option. I cannot seem to find such an option in SQL Backup.

Many thanks

regards

Graham Goodwin

petey · December 22, 2010 8:35PM

The KEEP_CDC option will be available in the next release of SQL Backup.

If you are open to using patched versions of SQL Backup, we can prepare a patched 6.4 version for you that supports the KEEP_CDC option.

Thanks.

GrahamGoodwin · December 23, 2010 4:55AM

Thank you for your reply. Yes a patch would be great.

Many thanks.

Graham Goodwin

petey · December 23, 2010 4:59AM

Try patch 1023, downloadable using the following URL:

ftp://support.red-gate.com/Patches/sql_ ... 0_1023.zip

That archive contains the SQL Backup Agent executable file (SQBCoreService.exe). To replace the existing service executable file, do the following:

- ensure that no SQL Backup processes are running
- stop the SQL Backup Agent service, or disable the cluster resource if on a cluster
- rename the existing executable file (SQBCoreService.exe) in the SQL Backup installation folder
- extract and place the patched executable file into the same folder
- restart the SQL Backup Agent service/cluster resource

Thanks.

petey · December 24, 2010 2:45AM

There was a bug in the patch that was released yesterday. Anyone who's downloaded it, please download a newer version (using the same URL), as the previous version prevented restores of large databases.

Apologies to those affected.

SQL Server 2008 Change Data Capture Support

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk