Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Resetting Exchange Transaction Log Numbering sequence

Posted on 2009-05-19
Medium Priority
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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

604 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