I know something about SQL but I am not a Guru.
So I have a question about indexing with SQL databases.
After the weekend always our log file is very big. Grows up to 80GB.
The DB is nearly 100GB.
During the week the log backup works fine and log file is filled with 1% not more.
After the weekend the logfile is again 80GB and filled with 1%.
I have seen we have a maintenance job running which recreates the indexes.
What can I do, not to have so big logfiles ?
How bigger companies are doing this ?