How can we help you today? How can we help you today?

SQL Server 2008 Change Data Capture Support

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
GrahamGoodwin
0

Comments

4 comments

  • 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.
    petey
    0
  • GrahamGoodwin
    Thank you for your reply. Yes a patch would be great.

    Many thanks.

    Graham Goodwin
    GrahamGoodwin
    0
  • 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
    0
  • 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.
    petey
    0

Add comment

Please sign in to leave a comment.