What is the .LDF File Extension?
.LDF File Extension Description:
The .ldf file extension defines SQL Server Transaction Log Files. SQL Server, developed under Microsoft, is a relational database management system (RDBMS) that maps a database over a defined set of operating-system files.
LDF files are one of three file types that SQL Server has. This type of file is considered as a log file, which ends with the .ldf extension and holds all of the log information that a database does LDF files are necessary for recovering data and serves as their backup. The SQL Server is not capable of enforcing the .ldf extension but uses it as a default for identifying transaction log files.
The information files with the .ldf extension include the transactions and the modifications applied to the database. These modifications involve all deletes, inserts, and updates.
The records that LDF files hold support three operations. The first operation that LDF files support is the recovery of individual transactions. This means that if a ROLLBACK statement is issued by an application, the .ldf file is used to reverse that operation. Another is that if the server should detect an error, like having the communication with the client lost, the log records with the .ldf extension will be used to back up the incomplete transaction.
The second operation supported by LDF log files is the recovery of all transactions that are incomplete when the server (SQL) is started. This indicates that if a server running under SQL fails, incomplete transactions happen. The LDF file then rolls back to a recovery point where the database is fully functioning.
Rolling stored databases forwarded to the point of failure is the third operation supported by files with the .ldf extension. This means that a database can be restored right before its failure point.
Transaction log files with the .ldf extension can be positioned on either NTFS or FAT file systems. They cannot be positioned on file systems that have been compressed.Author: Microsoft Corporation
Author URL: http://www.microsoft.com/sql/default.mspx
Related Applications: Microsoft SQL Server, Microsoft Access
Common Path: N/A
Run a Free Scan to check for LDF related errors & to optimize PC performance.
Do you have errors with .LDF files?
What Causes .LDF files Errors?
.LDF files errors are potential critical Windows file system errors and are brought on by a corrupted program registry that you should repair right away to protect against even further failure in other applications and/or hardware. As long as the errors continue your system stays capable of possible blue screen errors, device failure and fatal crashes.
What are the Symptoms of .LDF files Errors?
.LDF files error symptoms include software lock ups, start up or shut down troubles, jerky system operation, laggy behaviour, input halts, beeping sounds, problems loading program files as well as problems while installing programs.
The following products are free to try. We have found them to be of the highest quality and value. They have been extremely useful in our own pc troubleshooting and maintainance and we highly recommend trying them out for yourself.
With a lightning fast free scan and the largest authentic spyware detection database we have seen, Anti-Malware Pro finds and removes threats to your PC stability and security. Download Anti-Malware Pro
DriverFinder will scan your system for driver and software updates. Its easy to use interface makes keeping your drivers updated quick and simple. They will even send you an email notification when new driver updates are available for your system! It doesn't get any more convenient than this. Download DriverFinder
Browse File Extensions by Name:
Is your File Extension missing?
Help us to make errorDecoder.com the best resource we possibly can by submitting you very own file extension details. If you have detailed information on any file extensions please let us know by visiting the following link.Submit File Details Form