Behavior:
If there is no maintenance plan that backs up the transaction logfile of the database, it is possible that this file will grow up to hundreds of GB. This can cause massive performance issues and timeouts in DocuWare.
Solution:
Shrink this file to e.g., 100 MB using the following command:
MSSQL 2000/2005
BACKUP Log DatabaseName WITH NO_LOG
DBCC SHRINKFILE (DatabaseName _Log, 100)
MSSQL 2008/2012/2014/2016
Use DatabaseName
GO
Alter Database DatabaseName Set Recovery Simple
GO
DBCC SHRINKFILE ('DatabaseName_log', 100)
GO
Alter Database DatabaseName Set Recovery Full
GO
Note:
This solves the problem only temporarily, as the logfile will grow again if you don't set up a maintenance plan in order to back up the logfile automatically.
KBA is applicable to On-premise Organizations ONLY.
