Microsoft SQL Server transaction log file is growing and growing?

The transaction log file of our Microsoft SQL server with the Xpert.ivy Server database is growing and growing.

If I limit the size of the log file then I get error message if the log file is full. If I execute a Delete statement on the table ILOG_Log then the XpertServer_log.LDF will not decrease. In fact it is growing. The Xpert.ivy Server Database itself is not very large only the LDF file is huge.

What is it? How can I turn this off? Any other changes?

ivy3

asked 13.09.2010 at 09:54

Katharina Ka...
(suspended)
accept rate: 0%

One Answer:

active answers oldest newest most voted

The *.ldf file is the transaction log file of Microsoft SQL Server databases. It stores any changed you made to the database since the last backup of the database. So Xpert.ivy Server does not store directly to this file and can not influence it.

Because the transaction log stores all changes since the last database backup you can limit the *.ldf file by backup the database periodically.

Another possibility is to change the recovery mode of the database to Simple. In this case the .ldf file stores only the transactions that are not yet commited. Commited transactions are deleted from the *.ldf file. Note that with this recovery mode it is not possible to restore the database to a specific point in time. You can only recover it to the time you backuped it.

link

answered 28.09.2010 at 04:09

Tamas KIS
(suspended)
accept rate: 60%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "Title")
image?![alt text](/path/img.jpg "Title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Tags:

ivy3 ×24

Asked: 13.09.2010 at 09:54

Seen: 2,091 times

Last updated: 13.09.2010 at 09:54

Microsoft SQL Server transaction log file is growing and growing?

Follow this question

Related questions