Forum Discussion

sqltleo's avatar
sqltleo
Copper Contributor
Jan 22, 2024

Preserve CDC info while restoring (-KeepCDC)

I would like to preserve the CDC information while refreshing the development using production backup. We use a sophisticated powershell script to perform the restores. I am a little unclear on the u...
olafhelper's avatar
olafhelper
Bronze Contributor
Jan 23, 2024

However, I am not sure what value to pass in the powershell.

Default value: False

The parameter is a boolean value: False/True

sqltleo's avatar
sqltleo
Copper Contributor
Jan 25, 2024
Thank You olafhelper for the information. I have updated PowerShell code to below:
Restore-DbaDatabase -SqlInstance $ServerInstanceName `
-DatabaseName $dbName `
-Path $file.FullName `
-DestinationDataDirectory F:\MSSQL\DATA `
-DestinationLogDirectory G:\MSSQL\Logs `
-WithReplace `
-EnableException
-KeepCDC True <----This is the change added

Regards,
Leo
  • Riddhi640's avatar
    Riddhi640
    Copper Contributor
    May 15, 2024

    sqltleo Keep CDC is available for Microsoft.SqlServer.Management.Smo.Restore ?

    I need to restore a database with CDC from one env to another so I want to know if I can restore with all CDC tables. 

Resources