What are the challenges you face when working across database platforms? Take the survey
Options

SQL Server 2008 Change Data Capture Support

GrahamGoodwinGrahamGoodwin Posts: 25
edited December 24, 2010 2:45AM in SQL Backup Previous Versions
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

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Thank you for your reply. Yes a patch would be great.

    Many thanks.

    Graham Goodwin
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.