Does Netbackup support the MS SQL Server feature "WITH KEEP_CDC"?

Article: 100004532
Last Published: 2022-10-19
Ratings: 0 1
Product(s): NetBackup & Alta Data Protection

Problem

Microsoft option KEEP_CDC is designed 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. 

Is this option support with the NetBackup for Microsoft SQL Server database agent?

Error Message

N/A

Solution

Pre Client version 9.1 this is not supported.

From Client Version 9.1 onwards there is a batch file option

KEEPCDC

Preserves the change data capture settings when a database or log backup is recovered. This option is not valid with the RECOVEREDSTATE NOTRECOVERED option.

Possible values are TRUE, FALSE

Default: FALSE

Required: No

Applies To

Microsoft SQL Server

Netbackup client for SQL server 9.1 release notes

 

Was this content helpful?