January 17, 2020 at 4:06 pm
What is the recommendations for backups in distributed availability groups?
I have AG setup in 2 sites for DR but the backups fail on the forwarder (primary node in Second AG)
Log backup for database "DBA_Test" on a secondary replica failed because the last backup LSN (0x00000028:00000993:0001) from the primary database is greater than the current local redo LSN (0x00000028:00000992:0001). No log records need to be backed up at this time. Retry the log-backup operation later. [SQLSTATE 42000]
They also fail sometimes with the same error on the Secondary Node in Primary Ag.
You would usually set the backups to run on the Secondary Node but it seems with DAG everything needs to run on the primary. Probably isn't a need for backups in second AG as we already backing up.
There seems very little documentation about distributed availability groups
January 18, 2020 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
January 21, 2020 at 9:02 am
This was removed by the editor as SPAM
January 22, 2020 at 11:49 pm
Did you check the redo queue? You can get that error with any type of availability group when the secondary falls behind or the redo thread is blocked...scenarios along those lines. It's not necessarily something just with distributed availability groups.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply