I have a asset tracking app which tracker people and cars, we use sql server 2014 enterprise
Currently the MDF is at 3gb and the LDF is at 33GB
the recovery model is set to full, and i've just left it that way, but now the log file is becoming too big, I need to manage that properly
One suggestion from the team was to set the log file to 10GB, and have a sliding thing so it only keeps the latest data (we only really care about the last 1 month/ 1 week but it we keep up to 1 year)
Does this sliding thing actually exist?
based on the brief above, how would you manage this large log file?