Thanks George.

Basically the size should be enough to handle your largest amount of log activity between log backups, so if your largest log backup is a couple of GB say, the log needs to be slightly larger than that. Growth factor should not be a %, actual MB value should be relative to size of log and minimise the no. of vlfs created.

Looking to last couple of days Log Backup:

From yesterday, I have largest Log Back up size is - almost 3 GB (6 PM)and before that - around 1 GB (4 PM)

Currently I have Log file set up: Initial Size is 3 MB and Growth is 10% Unrestricted.

Could you please guide me what should be the ideal size I should change it for Initial size and I will change it from % to What size?

Thanks