June 6, 2021 at 1:40 am
I set up 2 servers with AG and a secondary is readonly. SQLSERVER 2016 on Windows 2016
Everything is up, AG is synced up and data comes back.
The odd part is the databases in the AG won't take a trans log backup? I can run the statement, but nothing happens. It doesn't come up in backup history. The TLog backup job doesn't fail though.
Any ideas of what I'm missing
June 7, 2021 at 2:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
June 7, 2021 at 12:26 pm
Hi, how you are doing this backups? Manual, SSIS task or some procedure eg. Ola Hallengren? What with backup files, are they generated? You may making log backups on other replica and this is why you don't see it on backup history.
June 7, 2021 at 12:52 pm
I just figured it out and you were correct.
It was set up to the secondary and NOT the primary.
Changed it back to primary and it works. Thanks!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply