My database is in the simple recovery mode. During bulk-operations it is growing very high and utilization of memory space is very high and we had a seperate drive for ldf files. After some time again it came to its original size.
Pl, let know why it is growing when it is in simple recovery? The cause might be SQL Server may not have enough time to run a checkpoint and complete the log truncation? Correct if I’m wrong?
Let me know the best practice to maintain the log file when it is in simple recovery?