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 eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

After hours on line I found a solution which pointed to the inherited Active Directory permissions . You have to give/allow permissions to the "Exchange trusted subsystem" for the user in the Active Directory...
Check out this step-by-step guide for using the newly updated Experts Exchange mobile app—released on May 30.
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

690 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