Views:

Behavior:
If there is no maintenance plan which backs up for the transaction logfile of the database it is possible that this file grows 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 won't set up a maintenance plan in order to backup the logfile automatically.

This article is valid for DocuWare versions: all | transaction log shrink ms sql #FAQID_1176
Comments (0)