Sample Header Ad - 728x90

The remote copy of database has not been rolled forward to a point in time that is encompassed in the local copy of the database log

0 votes
1 answer
5238 views
Can someone help me with the issue I'm dealing with? I had to force failover from my primary datacenter to my secondary datacenter and I forgot to disable the log backup job. Meanwhile the new secondary servers were shut down for a couple of times because of switch update. The new changes on the database weren't committed on them but log backup job in the primary date center server started and the log file was reused without acknowledgment from the secondary nodes! In the result the database in the secondary server became unhealthy. I have no idea how the log file was reused without acknowledgment! Can you help me with this? I checked the the error logs on all servers and I got this error The remote copy of database has not been rolled forward to a point in time that is encompassed in the local copy of the database log **I wasn't expecting the log file to be reused without acknowledgment from the second server. log file was reused without acknowledgment from the secondary nodes The remote copy of database has not been rolled forward to a point in time that is encompassed in the local copy of the database log**
Asked by alireza (1 rep)
Jul 23, 2023, 12:01 PM
Last activity: Jul 25, 2023, 03:22 PM