The Harddisk is full, database file rms.ldf is hugh

Harddisk is full, database file rms.ldf is huge.

Cause:

The recovery mode of the database is not correct. It should be “simple” and not “full”.

Solution:

1. Reduce ldf.
2. Change recovery mode to simple.

English links:

https://docs.microsoft.com/en-us/previous-versions/sql/2014/relational-databases/backup-restore/view-or-change-the-recovery-model-of-a-database-sql-server?view=sql-server-2014

https://docs.microsoft.com/en-us/previous-versions/sql/2014/relational-databases/logs/manage-the-size-of-the-transaction-log-file?view=sql-server-2014

German links:

https://docs.microsoft.com/de-de/sql/relational-databases/backup-restore/view-or-change-the-recovery-model-of-a-database-sql-server?view=sql-server-ver16

https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?view=sql-server-ver16