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: 25
0
Like
https://www.lansweeper.c...nd-improve-performance/

Can the above be automated if using the old SQL express back-end?
Esben.D
#1Esben.D Member Administration Posts: 1,982  
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: 25  
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

Action Open Teams/SfB Chat with user
by  dshu   Go to last post Go to first unread
Last post: 6/25/2020 7:04:55 PM(UTC)
Action Find lost space the easy way (spacesniffer.exe)
by  krozar  
Go to last post Go to first unread
Last post: 5/5/2020 10:27:33 PM(UTC)
Lansweeper Querying a web server or web services
by  mmo   Go to last post Go to first unread
Last post: 5/5/2020 9:00:36 PM(UTC)
Action Password Status
by  brodiemac-too  
Go to last post Go to first unread
Last post: 4/23/2020 9:01:03 PM(UTC)
Action Email user
by  Michael Kop   Go to last post Go to first unread
Last post: 4/7/2020 11:24:12 AM(UTC)
Lansweeper actualizacion de datos importando csv
by  jhon freddy  
Go to last post Go to first unread
Last post: 3/31/2020 9:04:45 PM(UTC)
Lansweeper Asset Actions - RunAs Prompt
by  Socal_s197   Go to last post Go to first unread
Last post: 3/26/2020 10:02:16 PM(UTC)
Lansweeper Remote Registry 2019
by  CyberCitizen  
Go to last post Go to first unread
Last post: 3/6/2020 12:25:39 AM(UTC)