SQL Server databases created with two types of file:
Data File (File with extension .MDF/.NDF)
Log File (File with extension .LDF)
Data File can be one or more than one but physical log file will always remain one for each database. You have control over the size of log file but you can’t have more than one physical log file. There are so many mysteries and myth roaming around log file in developer’s mind so I thought to take an initiative to break this ice.