?
Solved

NTFS transaction log disable

Posted on 1998-04-23
7
Medium Priority
?
3,527 Views
Last Modified: 2013-12-28
can the NTFS recovery transaction log be disabled...
and if not is there a way to increase the log space
0
Comment
Question by:biluther
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 

Expert Comment

by:TMS
ID: 1777086
These are different things. NTFS has a feature that ensures complete update to files. This add safety to the NTFS file system, as it is less likely to corrupt the file system (file allocation, bitmap and NTFS structures scattered all around an NTFS partition)
The NTFS file system takes great care to write and record changes as they are made to the disk, so it is possible to restart in a 'known' state when the system restarts and tries to 'recover'...
Truncate log on check point is a SQL server option that allows the syslog table to be truncated (read: lost) when SQL server checkpoints.
Abstract from the SQL server books online...
The checkpoint mechanism is an automatic means for guaranteeing that completed transactions are regularly written from SQL Server's own disk cache to the database device. A checkpoint writes all dirty pages cached pages that have been modified since the last checkpoint to the database device.


0
 

Author Comment

by:biluther
ID: 1777087
Edited text of question
0
 
LVL 1

Expert Comment

by:z1
ID: 1777088
Sorry answer to both questions in NO as far as I know. Answer to the 1st one is NOT FOR SURE - it's first and basic fs feature, if you need one which never writes, go on...
Are you writing LARGE files using NT compression? Comment only if so, I'll go on.
z1
0
Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

 
LVL 2

Expert Comment

by:tbaffy
ID: 1777089
The NTFS logfile ($logfile) can range in size from 4 MB to 10 MB and is circularly reusable.  What this means is that the transaction entries in the log file wrap around back to the beginning of the file when the file reaches maximum size.  There is little point in making this file larger when it automatically recycles its own space.

Tom
0
 
LVL 7

Accepted Solution

by:
BlackMan earned 600 total points
ID: 1777090
To add on tbaffy's comment, it is correct that the logfile i circulary reusable. The Log File Service (LFS) sees it as an infinitely large file, but if it should happe to run full, LFS halts I/O activity, that means, blocking for creation and deletion of files. Then it complete waiting transactions, calls the cache manager to flush unwritten data, and then continues to process I/O's.
Under normal circumstances, you will never notice this, as it has no effect on executing programs.
If you use a FAT volume, there is no transaction logging..
0
 

Author Comment

by:biluther
ID: 1777091
suggestion of using FAT is helpful...

0
 

Expert Comment

by:eliuha
ID: 30504080
the punched card does not have a transaction logging as well
http://en.wikipedia.org/wiki/Punched_card

what are you trying to do ? or in other words, why don't you like the log ?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Determining the an SCCM package name from the Package ID
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question