At a minimum, every
SQL Server database has two operating system
files: a
data file and a log
file.
Data files contain
data and objects such as tables, indexes, stored procedures, and views. Log
files contain the information that is required to recover all transactions in the database.
read more >>