Skip to main content
Share Your Experience: Take the 2024 Developer Survey

New answers tagged

2 votes

2x SQL Server 2019 in AlwayOn group - how to remove transaction log

There are supposed to be some way how to purge the log by doing some kind of backup, but never found real help on that. They're called Transaction Log backups. For a database that's set to the Full ...
J.D.'s user avatar
  • 37.9k
2 votes

2x SQL Server 2019 in AlwayOn group - how to remove transaction log

Simply put, we don’t need the log, we don’t want the log, how to get rid of that? You don't. SQL Server requires it to run and Always On requires it to function properly.
Sean Gallardy's user avatar
1 vote

SQL 2017 log reuse issue

What I didn't know is that for databases in AGs, VLFs can remain with a status of 2 even after they are freed up by a backup. https://www.sqlskills.com/blogs/paul/lazy-log-truncation-or-why-vlfs-might-...
Bruce Benson's user avatar

Top 50 recent answers are included