Keyword KEEP_CDC not recognized in RESTORE statement
Add support for the KEEP_CDC keyword. Example:
RESTORE DATABASE MyDB
FROM DISK = N'\\SOMEWHERE\MyDB_FULLBACKUP1.BAK'
WITH FILE = 1,
MOVE N'MyDB_DATA' TO N'M:\SQLData1\SQL_DATABASE\MyDB.MDF',
MOVE N'MyDB_LOG' TO N'M:\SQLLogs1\SQL_DATABASE\MyDB_LOG.LDF',
RECOVERY, REPLACE, STATS = 1, KEEP_CDC, NEW_BROKER, RESTRICTED_USER
Currently the formatting process errors out.
1
vote
Kevin Ruff
shared this idea