cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
FrankSc
Lansweeper Tech Support
Lansweeper Tech Support

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.

ADP-notifications-1.jpg

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.

ADP-notifications-2.jpg

How to quickly reduce your database size

Step 1: Determine your database server

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.

Step 2: Stop the Lansweeper service

Stop the Lansweeper Server service in Windows Services on all of your scanning servers.

procedure-stopping-the-lansweeper-service.jpg

Step 3: Stop your web server service

Stop your web server service in Windows Services. Keep in mind that this will log everyone out of the console. Your webserver service is either IIS Express or World Wide Web Publishing Service (IIS).
procedure-stopping-the-web-server-service.jpg

Step 4: Run DatabaseMaintenance.exe

Run the following tool on your Lansweeper server:
Program Files (x86)\Lansweeper\Tools\DatabaseMaintenance.exe
menu-databasemaintenance.jpg

Step 5: Truncate logs, Shrink and Compact

Select Truncate logs, then Shrink and then Compact. Each operation may take a while to complete.

This step will clear the tblNtlog and tblNtlogMessage tables in your database, deleting all Windows event log information from your database. Event log data generally takes up the most space. You can still scan new events afterward.

Step 6: Start the web service

Restart the webserver service in Windows Services.

procedure-starting-the-web-server-service.jpg

Step 7: Start the Lansweeper service

Restart the Lansweeper service in Windows Services and wait a few minutes for the automated cleanup options to finish running.

procedure-starting-the-lansweeper-service.jpg

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.

For more information about managing your database size, refer to this knowledge base article.
New to Lansweeper?
Article Dashboard
Version history
Last update:
‎12-13-2022 02:36 PM
Updated by: