I have an issue with a log file which I am trying to solve. FYI. I don't see any long running, open transaction which would fill the log file to 70GB.
Total 12 servers:
ON prem 4 servers: SQL01, SQL02,SQL03,SQL04 (On prem) SQL01 is primary, rest of the servers are secondary.
DR site, 4 servers: SQL11, SQL12, SQL13, SQL14. There is a distributed availability group between SQL01 and SQL11. Things are great, no issues but we created another 4 more server (SQL21,SQL22,SQL23,SQL24) yesterday and created distributed availability group between SQL11 and SQL21. Now the log file size is close to 70 GB. I ran a log backup on SQL01 twice already, tried resizing the log file size to 20 GB but the size is still 70 GB and growing. Any advise?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]