Hi, I am using a software which is using SQL DB. Each time there is an error (one of the tasks fails) the DB grows. I would say over 1G per day! Currently I have DBs which are 45G and I am running out of space.
Anyone has any idea how to shrink the DBs or do something to reduce the size.
The LDFs don't grow as much as MDF. They are something like 1M.