Ask the Community
Groups
Ksubscribers transaction log large - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="problem">PROBLEM</h2> <p>The ksubscribers transaction log file is large.</p> <h2 data-id="solution">SOLUTION</h2> <p><strong>Note: </strong><strong>We strongly suggest that a SQL database backup be taken against the database prior to running any SQL command.</strong></p> <p>You can easily shrink the transaction log file by following the steps below.</p> <p>Execute the SQL Query below to change the database into <strong>SIMPLE</strong> recovery mode. This will allow maximum shrinkage of the transaction log:</p> <p><em>Alter database <YourDatabaseName> Recovery simple</em><br><em>GO</em></p> <p>Execute the SQL Query below which will attempt to shrink the transaction log to 10 MB. This <strong>should</strong> remove all the empty space from the transaction log:<br><br><em>DBCC SHRINKFILE('ksubscribers_log',10)</em></p> <h2 data-id="additional-information">ADDITIONAL INFORMATION</h2> <p>You can run these commands at any time as this will not affect the SQL performance of the Kaseya server.</p> <p> </p> </article> </main>