Solved

NTFS transaction log disable

Posted on 1998-04-23
7
3,114 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
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
Will my email signature work in Office 365?

You've built an email signature using raw HTML code in Office 365, but you can't review how it looks with Transport Rules. So you have to test it over and over again before it can be used. Isn't this a bit of a waste of your time? Wouldn't a WYSIWYG editor make it a lot easier?

 
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 200 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
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…

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now