I am running into a strange situation that I have not been able to resolve. I have a 2 node Basic AG running sql server 2016 standard. I am trying to add the reportserver DB to an AG, but it keeps failing on joining the DB to the secondary node.
I have done the below:
- fully recovered the DB on node1 (primary), made sure its in Full recovery mode
- took a fresh backup, AND log backup immediately after it
- restored both the full and log backup to Node2 (secondary) leaving it in restoring state.
Back on primary I created an AG via the GUI, but when I get to the end it sits on joining the DB to the AG in node2. I get a few different errors, which essentially mean the same thing:
"the remote copy of the db "reportserver" has not been rolled forward to a point in time that is encompassed in the local copy"
"the mirror db "reportserver" has insufficient transaction log data to preserve the log backup chain."
I know these mean that should be additional log backups to restore, but I had just prior to this taken the full AND log backup and restored both of them to the secondary, so there should be no other backups to restore... The only thing I can think of is that something is still writing to the log on the primary, but as far as I am aware, even if that is the case, joining the DB to the AG should still work as the currently un-backed up portion of the log should be streamed to the secondary replica during the sync process. I skipped the listener configuration for the time being. I also stopped the SSRS service on both nodes prior to doing this.
Has anyone encountered this before and had success fixing it? Is it because it is the reportserverDB, and it can't be joined to the same AG as reportservertempDB?
I have tried automatic seeding, and join only mode, and the strange thing is that automatic seeding gives me NO errors during the AG setup, but the DB does not ever show up on Node2. When i do join only, that is when I get the errors above. I'm pretty much baffled by this. I have 6 other DB's on these nodes that are each in their own basic AG, and I have not run into any issues with them.