My tran log is set to autogrow, by 256 mb, to unlimited. I fill the log but it doesn't grow. I can grow it manually. Why is it not autogrowing?
If it's relevant, it's in a 4 replica AG.
This is a test db / issue so we're talking small numbers here, MBs.
Can't delete but I've answered my own question. Should have researched more before posting.
My 2 x Synchronous databases were not in sync. Once this was resolved, growth occurred.
November 22, 2022 at 1:25 pm
Nice work. I marked your second comment as the answer to the question. No need to delete your initial post. You answered it and shared that with others. All good.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2022 at 5:52 pm
Interesting that you've had the same problem with posts automatically being replicated, Grant. You should report that on the "Site Issues" forum and then send Webmaster@SQLServerCentral.com a heads-up. You're not the first person that I've seen in the last week have the same issue.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 22, 2022 at 6:44 pm
Whoops! Weird.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply