Hi,
Thanks for the response but I was only notified about it yesterday.
I had tried your option 1 but not 2. To be honest,
Because it was time sensitive, I ended up restoring the previous day's backup which took place before the event happened. Not ideal, but it fixed the issue.
Terry.