<< Click to Display Table of Contents >> Navigation:  Help > Troubleshooting > Software Installation > 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