What is the xx_log.LDF file do?

Stefan

Hi,

What is the Log.LDF file used for? Can it be deleted?

Thanks,
Stef

Jul 20 '05 #1

Subscribe Post Reply

26523

Trevor Best

On Thu, 14 Aug 2003 11:42:01 -0400 in comp.databases.ms-sqlserver,
"Stefan" <ni***@studioweb.com> wrote:

Hi,

What is the Log.LDF file used for? Can it be deleted?

It's the log file where all the transactions are logged, the server
will use this to automatically recover your database after a crash.
Not a good idea to delete it.

--
Ride Free (but you still have to pay for the petrol)

(replace sithlord with trevor for email)

Jul 20 '05 #2

Erland Sommarskog

Stefan (ni***@studioweb.com) writes:

What is the Log.LDF file used for? Can it be deleted?

No, you will not be able to access your database if you do. As Trevor
said, the transaction log is there to make it possible to recover the
database in case of a crash. SQL Server also uses this file if a
transaction runs into a problem and must be rolled back.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #3

ntlfree

Thanks for your answer.
But I think in some case, the .LDF file is so big size. Then I want to reduce it. Can I delete it? Are there affect with MS SQL system?

Sep 15 '05 #4

by: lkrubner | last post by:

I want to give users the power to edit files from an easy interface, so I create a form and a PHP script called "fileUpdate". It does a reasonable about of error checking and prints out some...

PHP

Not clear on what documentation means here [pxlpluker]

by: pxlpluker | last post by:

Not clear on what documentation means here. What exactly does the underlined text mean. w & a obviously mean you are going to update the file. So what does the + mean on w+ & a+ mean? Also please...

Python

What I want in an editor/IDE

by: Chris Cioffi | last post by:

I started writing this list because I wanted to have definite points to base a comparison on and as the starting point of writing something myself. After looking around, I think it would be a...

Python

What is the easiest way to query a remote XML file on someone elses Linux box using secure communication?

by: Dan V. | last post by:

Situation: I have to connect with my Windows 2000 server using VS.NET 2003 and C# and connect to a remote Linux server at another company's office and query their XML file. Their file may be...

.NET Framework

Boost.Filesystem what would you add?

by: Steven T. Hatton | last post by:

Anybody looked at this stuff? http://www.boost.org/libs/filesystem/doc/index.htm Most of it seems fairly straightforward. If you happen to do thing such as put ~/code/c++/project in your...

C / C++

121

What IDE are you using?

by: typingcat | last post by:

First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode...

PHP

Problem doing an e-mail program in C

by: tyler_durden | last post by:

hi there peeps... like I say in the topic, I need to do an e-mail program in C language, and has to be made until the 3th of january..the problem is I'm having some problems with it. I was...

C / C++

What does it mean ?

by: ranjeet.gupta | last post by:

Dear All What does exactly below code means struct File { void* data; }; typedef struct File File; typedef File* fl;

C / C++

What's the difference/advantages between code behind and code inside?

by: Alan Silver | last post by:

Hello, Newbie here, so please forgive what is probably a basic question ... I see a lot of discussion about "code behind", which if I have understood correctly, means that the script code goes...

ASP.NET

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Similar topics