Resetting Exchange Transaction Log Numbering sequence

Posted on 2009-05-19
Last Modified: 2012-06-22

We are running Exchange 2003 SP2.

I have heard that the transaction log numbering sequence is limited to 1million.

The solution to this is to move all log files and checkpoint to another location.

My question is - what act actually resets the log sequence? Is it effectively deleting the checkpoint file so that the logs start from #1 again? What in layman's terms does the chk file do?
Question by:kam_uk
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
  • 3
  • 2
LVL 13

Expert Comment

ID: 24428405
What does the .chk file do?
The E##.chk file maintains the checkpoint for the Storage Group. The ## represents the Storage Group number with the First Storage Group file called E00.chk. This checkpoint file keeps track of the last committed transaction. If you are ever forced to perform a recovery, this file contains the point at which the replaying of transaction logs starts.
So ineffect the .chk file keeps track of the last transaction log that was committed to the database
What act actually resets the log sequence?
It is the combined process of moving both the log files as well as the .chk file that resets the log sequence
This MS article also talks about resetting the log sequence

Author Comment

ID: 24495218

So - if I moved the log files but not the chk file - would this cause database corruption?
LVL 13

Expert Comment

ID: 24499366
Not in all scenarios will it cause database corruption.....and one cannot be 100% sure.
The chk file keeps track of the last committed transaction log file and the point from where the log files should start the replay process.
The chk file is just like a pointer for transaction log replay.

Author Comment

ID: 24510244
Hi FearNoMore...

I was just thinking there would be database corruption because if the logs were moved manually but *not* the checkpoint file, then Exchange would be looking for logs that were no longer there? Whereas if the chk file was moved, then Exchange would essentially just start the log sequence from scratch?

LVL 13

Accepted Solution

FearNoMore earned 500 total points
ID: 24515091
Exchange would definitely look for the logs based on the chk file but if they are not present then it would generate an error and state that the log files could not be replayed since they were not found.
So in effect if the chk file is present and the log files have been moved manually, the database would definitely try to locate the log file that is referred by the chk file....but do remember that there is no actual log file replay taking place and hence there is no data being written into the database.
So since there is no data being written into the database, there is a low possibilty that the database would actually get corrupt.
But all in all, these are all process that are carried out internally by the Extensible Storage Engine (ESE) and hence we cannot be too sure that this will cause database corruption.
You should make sure that the chk file is also moved along with the other log files, to ensure that the log sequence is regenerated.
I hope this makes things clear

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to:…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

726 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