OK, so this might be a dumb question, but I’m wondering what the purpose of the log files associated with a SQL Server database are used for.
Now, I know that you can initiate a transaction with checkpoints from which you can rollback. I also know that any modification happens through the log so that it can automatically rollback should the process fail to complete.
But, unless you adjust the settings to truncate the log periodically, it seems to keep growing and growing. Why is this? It’s not as if you can recover from mistakes on occasions when you don’t open a transaction, and once something is committed it’s pretty much done. Why does the log maintain all that data, and considering that it does…why can’t you rollback from it even without a open transaction? Am I missing something?