on
09-08-2021
08:30 PM
- edited on
12-13-2022
02:36 PM
by
Nils
As both SQL LocalDB and SQL Server Express databases are limited in capacity by Microsoft to 10 GB, it is important to keep an eye on the size of your Lansweeper database, to prevent it from reaching its maximum size.
When the database is full or almost full, your Lansweeper server might stop functioning as it should, resulting in incomplete or out of date data. If your on-prem installation is linked to Cloud this may result in this same incomplete or out of date data being synced to Cloud, or your sync stopping altogether.
Additionally, if your database reaches its size limit during a Lansweeper update, the update may fail.
When the database reaches the size limit of 90% a notification will be shown in the on-prem web console.
This notification will only be shown to users that have the Access Configuration permission. The notification can be dismissed, and it will automatically disappear if the database size issue is resolved.
This article explains how you can quickly reduce your database size to avoid any impact on your sync with Cloud. The size of your database is listed in the Scanning Status widget or sync status section of the Configuration > Link With Cloud Site menu.
You can determine which database server is hosting your Lansweeper database by using the ConfigEditor tool. You can follow the instructions in this knowledge base article.
Stop the Lansweeper Server service in Windows Services on all of your scanning servers.
Program Files (x86)\Lansweeper\Tools\DatabaseMaintenance.exe
Select Truncate logs, then Shrink and then Compact. Each operation may take a while to complete.
Restart the webserver service in Windows Services.
Restart the Lansweeper service in Windows Services and wait a few minutes for the automated cleanup options to finish running.
If you keep running into the database size limit, we recommend moving your Lansweeper database to a licensed SQL Server edition that has no fixed database size limit. To move your SQL LocalDB database to SQL Server, you can follow the steps in this article. If you are already using SQL Server Express, you can follow these steps to move to another SQL Server instance.