clumnah
commented
4 years ago CDC requires you to restore the database with additional commands. Those commands are not available via Rubrik. The way you do it via the prepare script is run it like you normally would. When you look at the JSON file, you will see a field that says FinishRecovery. This by default is set to true. If you set this to false, your database will be recovered and left in NORECOVERY mode. You can then add to your process to say RESTORE DATABASE [DBNAME] WITH KEEP_CDC. If you had replication enabled in the database you would do a similar thing, except using KEEP_REPLICATION.
From: rwyoung01 notifications@github.com Sent: Wednesday, October 7, 2020 3:29 PM To: rubrikinc/rubrik-scripts-for-powershell rubrik-scripts-for-powershell@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: [rubrikinc/rubrik-scripts-for-powershell] Export SQL Database with CDC (#158)
What happened: I was told to use Prepare-ExportDatabaseJobFile.ps1 that would prepare a json file that would help me export databases with CDC.
What you expected to happen: could not get this to work with server that had multiple instances but would on one that did not.
How to reproduce it (as minimally and precisely as possible):
Anything else we need to know?: once I have a json file how does that help me with restoring a database that has Change Data Capture
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Frubrikinc%2Frubrik-scripts-for-powershell%2Fissues%2F158&data=02%7C01%7C%7Ceda85a1877a6496316c708d86af74282%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637376957483809928&sdata=cjNLkFWMOFHzBF9bFyMlupLCQOSxaebMDbTKZprW2Bs%3D&reserved=0, or unsubscribehttps://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAFKMBSF7XXKQZILS2A4SOSLSJS6QDANCNFSM4SHZ7ONA&data=02%7C01%7C%7Ceda85a1877a6496316c708d86af74282%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637376957483819921&sdata=9ULO9%2BrwOlbFPRelPZbva2fMYUbBb3rEqUPG%2FCWd0d0%3D&reserved=0.
What happened: I was told to use Prepare-ExportDatabaseJobFile.ps1 that would prepare a json file that would help me export databases with CDC.
What you expected to happen: could not get this to work with server that had multiple instances but would on one that did not.
How to reproduce it (as minimally and precisely as possible):
Anything else we need to know?: once I have a json file how does that help me with restoring a database that has Change Data Capture