→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
maxlieb901
Engaged Sweeper

Hello,
I would like to automate the process described here:
https://community.lansweeper.com/t5/troubleshooting-your/clear-tables-to-free-up-space-and-improve-p...
has anyone done this?

2 REPLIES 2
maxlieb901
Engaged Sweeper

Hi David,
Understood.
Just wanted to clarify - are those completely standard SQL server operations, or do they differ somehow?
Does the database maintenance tool do anything different from what I can do from SQL Server Management Studio?

David_GF
Lansweeper Tech Support
Lansweeper Tech Support

hi @maxlieb901 The historcy clean up options are run daily (at Lansweeper service start, and then every 24 hours). You could automate the Truncate/Shrink/Compact and rebuild indexes part by running a corn job or a scheduled task on your SQL Server, or with a script to be run when executing the script, but that falls outside of Lansweeper support.



~~~~~~~ (〃 ̄︶ ̄)人( ̄︶ ̄〃) ~~~~~~~
Sweep that LAN, sweep it!

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now