we have a problem with our Microsoft SQL Server 2019. We have 2 servers in Always On group with one database. Problem is the actual (real) DB size which is about 1GB, but it takes up around 15GB on the server. The problem seems to be the transaction log which logs every change in the DB.

There are a lot of data pouring into the database – small data, but a lot. This means a lot of SQL updates, inserts etc.

Both SQL servers are in VMs and those are backed up every day, so we don’t need any other backups, just small DBs. I understand that the log is there to make sure both servers in the AO group has the same data, but jesus, just synchronize DBs between servers and delete the log, no?

Nobody will ever use the backlog to revert the database to previous state, because we need the latest data and previous version would be a problem.

We tried to shrink the log, but since there is AO group it was unsuccessful and AI came up with some shady script which we are afraid to run. 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.

Simply put, we don’t need the log, we don’t want the log, how to get rid of that?