cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Indianrock
Engaged Sweeper
Our Lansweeper database is now sitting on an instance of Sql Server 2012 Enterprise. As of a few days ago the database transaction log mysteriously shrinks itself to about zero size every evening around 6pm. I don't mean the file itself remains fixed but the contents are truncated --- the file size itself drops from 5GB where I set it to zero.

Since I have sql server agent jobs set up to rebuild indexes nightly, I want the log to remain at about 5GB. So far I haven't found any windows scheduled tasks that would do this on either the lansweeper server itself or the sql server.
I'd really like to get this turned off but can't figure where to look.
Randy
4 REPLIES 4
Hemoco
Lansweeper Alumni
We personally don't perform any additional database maintenance. We checked with development and they do indicate that the shrinking behavior may be changed in a future update. It isn't really necessary anymore. Lansweeper used to perform the entire database cleanup in one go, resulting in a huge log file, but now does this in small batches.
Indianrock
Engaged Sweeper
Thanks. For now I'll change my index rebuild to do its sorts in tempdb. Or perhaps I don't need to run index maintenance at all if Lansweeper is handling such things itself ??
Hemoco
Lansweeper Alumni
The Lansweeper service automatically shrinks the log when a database cleanup has been completed. Database cleanups are performed when the Lansweeper service is started and subsequently every 24 hours. You cannot change this behavior.
Indianrock
Engaged Sweeper
Seems like nobody else has experienced this. I looked in the Lansweeper web console/configuration and sure didn't see process designed to do this.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now