Logifile

[nkagi]

Dear All,

My question is kinda of stupid. I would just like to find out if there is a difference between Transaction Log and a Log File.If there's a difference what is the difference.

[DanielaTm]

Transaction log files and log files are the same thing: as I know

Log files. Log files hold all of the log information used to recover the database.
There must be at least one log file for each database, although there can
be more than one. The recommended filename extension for log files is .ldf.


Every SQL Server 2000 database has a transaction log that records all transactions
and the database modifications made by each transaction. This record of transactions
and their modifications supports three operations:
■ Recovery of individual transactions
■ Recovery of all incomplete transactions when SQL Server is started
■ Rolling a restored database forward to just before the point of failure