...
Note: ODBC SQL Server client-side driver: from Framework v7.2 there is no restriction applied to the version of the SQL client driver that can be used
SQL Server Log Files
1. Log Files are used to track all changes in a database to, amongst other things, provide a point-in-time restore due to a failure.
2. To understand the volume of SQL Log File growth, you investigate what has been changed (and as such logged). Insula cannot assist with the analysis of log files, their growth, etc.
3. In terms of understanding Log Files and their size, growth, and management, Insula recommends implementing the appropriate Recover model for an organisation. Please review the official Microsoft documentation on this. eg. As a starting point - https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server?view=sql-server-ver15
4. In short, if an organisation's backup strategy is robust and point-in-time restore limitations are understood, a Simple recovery model may be suitable.
5. Where a different (ie. logging) model is used, periodic log shrinking should be done to ensure backups are complete, and logs are shrunk, to conserve disk space. This can be a scheduled/automated process and, again, should be done in accordance with Microsoft's official documentation.
...