ASP.NET WEB HOSTING. Fast windows web hosting at discount prices. Microsoft Windows 2008 server hosting. web site hoting Home    web hosting asp net Login  

Search FAQ-Home Ask question Help

 Categories

· Show all categories

FTP
Front Page
Email
Web Site
Domain Name
MySQL
MS Access
E-Commerce
Hosting
ASP
ASP.NET
PHP
Buy Hosting Account
Upgrade
Billing
Others
PERL
CodeBank
MS SQL
Virtual Private Server

· FAQ-Home


Question:  MS SQL:
What are .LDF files and why the files are locked ?



Answer:   LDF files are SQL Server Transaction Log File

Log file created by SQL Server, a relational database management system (RDBMS) developed by Microsoft; contains a log of recent actions executed by the database; used to track events so that the database can recover from hardware failures or other unexpected shutdowns.

LDF files are transaction logs. These logs contain a history of activity for both fully committed and partially committed transactions to the database (the .MDF file). After an unexpected shutdown, SQL Server can use the transaction log to restore the database to the exact state before the failure.

Transaction logs can be truncated once the database creates a checkpoint, which is a stable state of the database and the log file. RDBMS systems can then safely delete all log data up to the point of the checkpoint, reducing the log file size.

NOTE: LDF files can become very large in size. This is due to the fact that no checkpoint has recently been created. However, it also may be due to open transactions that have not yet been fully committed, or other locks on database records.



Last update: 2012-04-02 10:32
Author: admin

printer-friendly version Send to a friend
Show this as PDF file export as XML-File

Average rating: 2.7 from 5 (403 Votes )

Please rate this entry:
completely
useless

1

2

3

4

5
most
valuable
You cannot comment on this entry | Content Overview: MS SQL
  WINDOWS WEB HOSTING | ASP.NET HOSTING | WEB HOSTING | WINDOWS 2003 HOSTING PLANS
TERMS OF SERVICE |  CONTACT  |  PRIVACY POLICYHOMEMASTERCARDDISCOVERAMERICAN EXPRESSPAYPAL
Copyright BIZHOSTNET.COM All rights reserved.  All trademarks are property of their legal owners.
BIZHOSTNET.COM is a web hosting company specializing in the following Web Hosting Products:
Windows Hosting Windows Hosting Windows 2008 Hosting Windows 2003 Hosting Windows 2008 Hosting Windows 2008 Hosting Frame .NET Hosting Frame .NET Hosting ASP Hosting ASP Hosting ASP Web Hosting ASP Web Hosting ASP.NET Hosting ASP.NET Hosting ASP.NET 4.0 Hosting ASP.NET 4.0 Hosting ASP.NET 3.5 Hosting ASP.NET 3.5 Hosting ASP.NET 2.0 Hosting ASP.NET 2.0 Hosting ASP.NET 1.1 Hosting ASP.NET 1.1 Hosting Microsoft Frontpage Hosting Microsoft Frontpage Hosting PHP Hosting PHP Hosting PERL and CGI Web Hosting PERL and CGI Web Hosting DOMAIN NAMES STATUS CODE Domain Names Status Free Domain names Free Domain names
Free MySQL Database Free MySQL Database Free SQL Database Free SQL Database