Extreme-Advice: Transaction Log File (.LDF) in SQL Server along with ACID property and recover mode of database

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.

Read complete article here:

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: