Sometimes when we enable SCR on one database there is a possibility that the Target database is not syncing with the source database and after running test-replication commandlet it will show failed and display that ‘SGStandbyReplayLag *FAILED* Standby Continuous Replication for storage group ‘ storage group name’ on computer ‘Target server’ has configured replay lag t ime of xxxx and a replay queue length of xxxx. However, log replay is actually behind by a period of xxxx which is greater by more than the Failure window of xxxx. Either log replay is slow or is not making progress. Please investigate further.”
The above SGstandbyReplaylag error show that there is a problem with replaying the log on to the Target DB . For fixing this issue following are the steps.
On the DR server Browse to where the log files are located for the affected storage group .
Locate the Check point file it ‘ll be in the format Exx.chk (i.e E00.chk) .
Stop the replication service .
Delete the check point file .
Start the replication service again
