Hi,

I inherited one database which have 8 log files placed in different drives, DB size is 2.5 TB and there is a log shrink job every night.

As the log files are sequential written and usually it requires only one log file and the reason for adding 2nd is to avoid any halt in the operations if 1st gets full (may be disk is full) then it would use 2nd log file.

To check if second and on ward files grow in the database I deployed 2 scripts,

first scripts is checking if any log file other than first start growing

if growth is detected then second script will check the disk space where first log is place.

Today is my 5th day in monitoring and I found that any disk never got full (even I asked SA to share the reports on the server especially for disks) but atleast 4 logs are growing (upto 30GB) ever day (after shrink job).

All log files have initial allocation of 5G with unlimited growth.

Any idea or reason for growth of n log files when there is no disk space issue.