Hi,
I’ve recently had cause to restore my UAT environment from a point in time backup. This required both the FO and CE systems to be restored as this is a linked environment. Smoke testing post restore shows that there is a permissions issue with the account used for dual-write on some tables (but not all).
Having worked with SQL Server in the past I’m aware that restores can ‘orphan’ users and I’m wondering if this happens in FO/CE restores too.
Are there any known steps that need to be completed post a restore of a linked FO/CE system (specifically UAT) to avoid permissions issues?
Cheers,
Mike
Found the issue. It was a missing DW map that had not been recreated.
Note to self… check all maps after a restore to ensure that they are configured correctly.
1 Like