DB cleanup script

[William382]

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?

[William382]

Gotcha. If this isn't built into the cleanup tool, I'll leave it alone.

[Esben_D]

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.