How to resolve this is an always on environment?
- On the Primary: Set the recovery model of the Config DB to Simple
- Full backup
- Remove from Availability group - now the configDB exists on Primary but it is not synching to the Secondary
- On the Secondary: Delete the config DB
Did you just say delete the config DB??? - Yes, it's on the secondary. It's ok. The Primary isrunning and not in the AG
- On the Primary: Shrink the Log files to 1,024MB - just the logs
- Add the Config DB back to the AOAG
And all was well again - time for a coffee
No comments:
Post a Comment