Does LiteSpeed for SQL Server support the restore of Change Data Capture (CDC) data? See the following Microsoft article and the 'Keep_CDC' option and restore syntax.
http://msdn.microsoft.com/en-us/library/cc645938.aspx
To retain change data capture, use the KEEP_CDC option when restoring the database.
For more information about this option, see RESTORE http://msdn.microsoft.com/en-us/library/ms186858.aspx"
WORKAROUND:
The restore xp will need the @WITH='KEEP_CDC' (or "-W keep_cdc" from the command line)
Note:
This has not been tested by Quest Software. Please complete a full test cycle prior to implementing.
Per Microsoft:
KEEP_CDC should used to prevent Change Data Capture settings from being removed when a database backup or log backup is restored on another server and the database is recovered. Specifying this option when restoring a backup with the NORECOVERY option is not permitted.
