Ksubscribers transaction log large


The ksubscribers transaction log file is large.


Note: We strongly suggest that a SQL database backup be taken against the database prior to running any SQL command.

You can easily shrink the transaction log file by following the steps below.

Execute the SQL Query below to change the database into SIMPLE recovery mode. This will allow maximum shrinkage of the transaction log:

Alter database <YourDatabaseName> Recovery simple

Execute the SQL Query below which will attempt to shrink the transaction log to 10 MB. This should remove all the empty space from the transaction log:

DBCC SHRINKFILE('ksubscribers_log',10)


You can run these commands at any time as this will not affect the SQL performance of the Kaseya server.


Was this article helpful?
0 out of 1 found this helpful
Have more questions? Contact us