SQL Server 2008 Change Data Capture Support

GrahamGoodwin

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

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

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

Many thanks.

Graham Goodwin

petey

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

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.