Notification

Icon
Error

DB cleanup script - Script/CLI for the cleanup tool

Posted: Thursday, November 14, 2019 8:42:59 PM(UTC)
William382

William382

Member Original PosterPosts: 21
0
Like
https://www.lansweeper.c...and-improve-performance/

Can the above be automated if using the old SQL express back-end?
Esben.D
#1Esben.D Member Administration Posts: 1,956  
posted: 11/18/2019 4:13:35 PM(UTC)
Theoretically, yes. I'm not 100% sure but I think it does the following:

truncate logs: Truncates tblNtlog and tblntlogmessage

Shrink: This is similar to right-clicking the database in SSMS and using the Shrink task (for files)


Again, best you create a backup before doing this manually, just in case.
William382
#2William382 Member Original PosterPosts: 21  
posted: 11/18/2019 4:23:43 PM(UTC)
Gotcha. If this isn't built into the cleanup tool, I'll leave it alone.

Active Discussions

Lansweeper Software Missing Report
by  RC62N   Go to last post Go to first unread
Last post: 12/6/2019 6:09:28 PM(UTC)
Lansweeper Assets without Asset Location
by  JLangthaler  
Go to last post Go to first unread
Last post: 12/5/2019 12:44:19 PM(UTC)
Lansweeper Installed Memory report
by  lansend   Go to last post Go to first unread
Last post: 12/2/2019 8:15:53 PM(UTC)
Lansweeper Custom OID Report
by  bramassendorp  
Go to last post Go to first unread
Last post: 12/2/2019 4:42:48 PM(UTC)
Lansweeper Report thats showing Windows machines when AV is not like =
by  RC62N   Go to last post Go to first unread
Last post: 11/28/2019 5:56:51 PM(UTC)
Lansweeper dhcp addresses available
by  Cesco93   Go to last post Go to first unread
Last post: 11/28/2019 2:56:02 PM(UTC)
Lansweeper All Assets Report on all IP-addresses and MAC-addresses
by  Tommy75  
Go to last post Go to first unread
Last post: 11/27/2019 11:54:44 AM(UTC)