cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
William382
Engaged Sweeper III
https://www.lansweeper.com/knowledgebase/clearing-tables-to-free-up-space-and-improve-performance/

Can the above be automated if using the old SQL express back-end?
2 REPLIES 2
William382
Engaged Sweeper III
Gotcha. If this isn't built into the cleanup tool, I'll leave it alone.
Esben_D
Lansweeper Employee
Lansweeper Employee
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.