October 12, 2015 at 1:30 pm
I am working on adding DBs to the AG but for some reason I am getting this error.
"Joining DB on secondary replica resulted in error"
Msg: The remote copy of the database is not recovered far enough to enable DB mirroring or to join AG. Missing log records have to be applied to the remote DB by restoring the current log backups" Which I did. I took the log backup of DB1, restored it on DB2 with no recovery, but still I am getting the same error. Any help.
October 12, 2015 at 1:42 pm
have you checked for a job running on the server that is taking log backups?
The error is pretty descriptive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2015 at 1:58 pm
No backup or log backup job is running.
October 12, 2015 at 3:10 pm
How many secondary replicas have already joined the group, or is this the first one?
Please post the output of the following query
select bs.name, bs.server_name, bs.database_name,
bf.physical_device_name, bs.user_name, bs.backup_finish_date,
bs.type, bs.compressed_backup_size, bs.backup_size
from msdb.dbo.backupset bs inner join msdb.dbo.backupmediafamily bf
on bs.media_set_id = bf.media_set_id
where bs.type = 'L' and bs.database_name = 'somedatabase'
order by backup_finish_date desc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply