TwistedHelixis Posted July 15, 2021 Author Posted July 15, 2021 did you manage to take a look at the tool i sent you Yes I did, thanks. I was going to run it on the server over the weekend :0)
TwistedHelixis Posted July 18, 2021 Author Posted July 18, 2021 You definitely need to shrink the log file, set the recovery mode to simple, and limit its size 1Gb should be more than plenty. Out of interest, if I do this do I need to keep the database size reduzed, or is it clever enough to delete itself to stay under 1GB. I assume it does it itself but noticed some forums mention setting a backup for SIMPLE mode so the database stays small, which confussed me.
Steve21 Posted July 18, 2021 Posted July 18, 2021 Out of interest, if I do this do I need to keep the database size reduzed, or is it clever enough to delete itself to stay under 1GB. I assume it does it itself but noticed some forums mention setting a backup for SIMPLE mode so the database stays small, which confussed me. Most enterprise backup software (Veeam etc) has the option to truncate the logs once it backsup so it is automated for all intent, but depends what you're using really Steve
TwistedHelixis Posted July 18, 2021 Author Posted July 18, 2021 BTW I am back up to over 30gb, which takes the stress off. Planning to do a full migration to new OS over the next few months. Thanks for all your help
TwistedHelixis Posted July 18, 2021 Author Posted July 18, 2021 Most enterprise backup software (Veeam etc) has the option to truncate the logs once it backsup so it is automated for all intent, but depends what you're using really The local authority script doesnt backup Solus3, just SIMS & FMS
round2it Posted July 19, 2021 Posted July 19, 2021 hop did you get the space back was it the dbase shrinking 1
TwistedHelixis Posted July 19, 2021 Author Posted July 19, 2021 hop did you get the space back was it the dbase shrinking That got me the most amount of space :-)
TwistedHelixis Posted July 19, 2021 Author Posted July 19, 2021 Neat little tool so keep that one on standby. Yes, I notice it does a few other things also. Thanks
round2it Posted July 19, 2021 Posted July 19, 2021 an engineer gave it to me one time not sure if its freely available
Boredguy Posted July 19, 2021 Posted July 19, 2021 an engineer gave it to me one time not sure if its freely available It is handy when they left us that nice little tool. Makes DB shrinking nice and pain free
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now