What is a SQL Server transaction log file?

Published on August 19 2015 by LakshmiSaahul,Dhana Royal

What is a SQL Server transaction log file?

A SQL Server transaction log file is an integral part of every SQL Server database. Along with the data file, which has an MDF extension, the transaction log file with a LDF extension, makes a SQL Server database.

A SQL Server database can have more than one data file. These additional data files have an NDF extension. But there can be only one active LDF. Physically, there can be additional LDF files but this is only recommended in specific situations. In either case, SQL Server can only use one LDF file at the time.

- See more at: http://www.sqlshack.com/virtual-log-files-sql-server-transaction-log/#sthash.x0l2N6ik.dpuf

Advertising