Solved

Resetting Exchange Transaction Log Numbering sequence

Posted on 2009-05-19
5
1,070 Views
Last Modified: 2012-06-22
Hi

We are running Exchange 2003 SP2.

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

http://exchsrvr.org/E2K3/How%20to%20Reset%20the%20Transaction%20Log%20Numbering%20Sequence.htm

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?
0
Comment
Question by:kam_uk
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:FearNoMore
Comment Utility
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.
http://www.msexchange.org/articles/Understanding-Exchange-Information-Store.html
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
http://support.microsoft.com/kb/830408
 
0
 
LVL 3

Author Comment

by:kam_uk
Comment Utility
Hi

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

Expert Comment

by:FearNoMore
Comment Utility
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.
 
0
 
LVL 3

Author Comment

by:kam_uk
Comment Utility
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?

0
 
LVL 13

Accepted Solution

by:
FearNoMore earned 500 total points
Comment Utility
kam,
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
 
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
In this video we show how to create a mailbox database 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 Servers >> Data…
how to add IIS SMTP to handle application/Scanner relays into office 365.

743 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

14 Experts available now in Live!

Get 1:1 Help Now