i notice the first storage group is dismounted and when i try to mount it shows that one of the transaction logs is missing. How do i find out which transaction log is missing and to resolve this issue??
hi there,
I'm having weird issues with my Exchange 2007 that just started happening even though no recent changes have been made. All users are running XP Pro with Outlook 2003 on Exchange, cached.
all users are now disconnected and can't connect. OWA i can get to logon screen but can't actually log on.
i've tried taking off cached in Outlook and recreating Mailboxes and that doesn't work either.
Tried restarting Exchange server with no luck.
event viewer is giving these errors: 4001, 8197, 12014.
Any help or guidance would be greatly appreciated.
Peter
< Message edited by petertech88 -- 10.Aug.2010 1:34:56 PM >
A transaction log doesnt just go missing, except if it is quarantined or removed by an antivirus application! Make sure (if applicable) any file-level antivirus you may have on the exchange server(s) is configured to exclude the correct file extensions and local folders on the server(s)!
To see which transaction log file is missing, open a command prompt and run the following:
Change directory to the folder containing your mailbox database.
At the prompt, type ESEUTIL /MH DatabaseFileName.EDB
Scroll to the top and review the information. One of the entries shows the State and another one will show the Logs Required. Check the log files and make sure they are all there. Usually the last one is the E00.log file.
To determine the current number of the E00.log file, change directories to the path where the log files are stored.
Type ESEUTIL /ML E00.LOG
Check the LGENERATION value for this file and it should be the next log file in sequence.
Also type ESEUTIL /ML E00 and this will check ALL the log files in the path and confirm if any are corrupted or missing.
Hope this helps!
_____________________________
Ibrahim Benna - Microsoft Exchange MVP Forum Moderator Navantis
One thing to remember about the command prompt is that it does not like spaces in file or folder names. whenever you have a file or folder that has more than one word, always put it in quotes, such as:
ESEUTIL /MH "MAILBOX DATABASE NAME.EDB"
_____________________________
Ibrahim Benna - Microsoft Exchange MVP Forum Moderator Navantis
getting closer! the quotes worked and i've pasted the output below. However i don't see "State" or "Logs Required" in the output. any ideas what's wrong based on the output?
C:\Program Files\Microsoft\Exchange Server\Mailbox\First Storage Group>eseutil / MH "mailbox database.edb" Extensible Storage Engine Utilities for Microsoft(R) Exchange Server Version 08.01 Copyright (C) Microsoft Corporation. All Rights Reserved. Initiating FILE DUMP mode... Database: mailbox database.edb File Type: Database Format ulMagic: 0x89abcdef Engine ulMagic: 0x89abcdef Format ulVersion: 0x620,12 Engine ulVersion: 0x620,12 Created ulVersion: 0x620,12 DB Signature: Create time:11/20/2007 11:35:06 Rand:68912482 Computer: cbDbPage: 8192 dbtime: 496033885 (0x1d90e05d) State: Dirty Shutdown Log Required: 254796-254804 (0x3e34c-0x3e354) Log Committed: 0-254805 (0x0-0x3e355) Streaming File: No Shadowed: Yes Last Objid: 89680 Scrub Dbtime: 0 (0x0) Scrub Date: 00/00/1900 00:00:00 Repair Count: 0 Repair Date: 00/00/1900 00:00:00 Old Repair Count: 0 Last Consistent: (0x3DA64,20D,A9) 07/25/2010 15:14:19 Last Attach: (0x3DA66,9,86) 07/25/2010 15:22:54 Last Detach: (0x0,0,0) 00/00/1900 00:00:00 Dbid: 1 Log Signature: Create time:11/20/2007 11:35:00 Rand:68949603 Computer: OS Version: (5.2.3790 SP 2) Previous Full Backup: Log Gen: 251262-251277 (0x3d57e-0x3d58d) Mark: (0x3D588,2EE,83) Mark: 07/16/2010 16:08:34 Previous Incremental Backup: Log Gen: 0-0 (0x0-0x0) Mark: (0x0,0,0) Mark: 00/00/1900 00:00:00 Previous Copy Backup: Log Gen: 0-0 (0x0-0x0) Mark: (0x0,0,0) Mark: 00/00/1900 00:00:00 Previous Differential Backup: Log Gen: 0-0 (0x0-0x0) Mark: (0x0,0,0) Mark: 00/00/1900 00:00:00 Current Full Backup: Log Gen: 0-0 (0x0-0x0) Mark: (0x0,0,0) Mark: 00/00/1900 00:00:00 Current Shadow copy backup: Log Gen: 0-0 (0x0-0x0) Mark: (0x0,0,0) Mark: 00/00/1900 00:00:00 cpgUpgrade55Format: 0 cpgUpgradeFreePages: 0 cpgUpgradeSpaceMapPages: 0 ECC Fix Success Count: none Old ECC Fix Success Count: none ECC Fix Error Count: none Old ECC Fix Error Count: none Bad Checksum Error Count: found (2) Last Bad Checksum Error Date: 01/02/2008 02:49:02 Old bad Checksum Error Count: none Operation completed successfully in 1.969 seconds.
getting closer! the quotes worked and i've pasted the output below. However i don't see "State" or "Logs Required" in the output. any ideas what's wrong based on the output?
Actually the information is in there (I have taken a few lines out!):
C:\Program Files\Microsoft\Exchange Server\Mailbox\First Storage Group>eseutil / MH "mailbox database.edb" Extensible Storage Engine Utilities for Microsoft(R) Exchange Server Version 08.01 Copyright (C) Microsoft Corporation. All Rights Reserved. Initiating FILE DUMP mode... Database: mailbox database.edb File Type: Database Format ulMagic: 0x89abcdef Engine ulMagic: 0x89abcdef Format ulVersion: 0x620,12 Engine ulVersion: 0x620,12 Created ulVersion: 0x620,12 DB Signature: Create time:11/20/2007 11:35:06 Rand:68912482 Computer: cbDbPage: 8192 dbtime: 496033885 (0x1d90e05d) State: Dirty Shutdown Log Required: 254796-254804 (0x3e34c-0x3e354)
The State can either be Clean shutdown (meaning all transaction log files have been committed to the database and the log required to make it consistent are 0-0 or none) or dirty shutdown (meaning that the database was not gracefully shutdown and the log files mentioned in the logs required were not committed to the database).
In your case, 8 log files have not been committed (from E00003e34c.log to e00003e354.log). Can you confirm these files are in the transaction log path?
Also can you complete running the commands I presented in my original post (tasks 1 to 3 are done; continue from 4 onwards and post the results please).
_____________________________
Ibrahim Benna - Microsoft Exchange MVP Forum Moderator Navantis
In Windows explore folder I see: E000003e34C.log to E000003e054.log and between these 2 log files are 24 log files inclusive. ?
Something doesnt make sense! Log files should be in sequence. As you can see from the previous output, E00.log has an LGeneration value that matches the last log file required.
C:\Program Files\Microsoft\Exchange Server\Mailbox\First Storage Group>eseutil / ML E00.LOG Extensible Storage Engine Utilities for Microsoft(R) Exchange Server Version 08.01 Copyright (C) Microsoft Corporation. All Rights Reserved. Initiating FILE DUMP mode... Base name: E00 Log file: E00.LOG lGeneration: 254804 (0x3E354)
Can you now run ESEUTIL /ML E00 and this will check all log files for sequence and corruption.
_____________________________
Ibrahim Benna - Microsoft Exchange MVP Forum Moderator Navantis
first step - make a copy of all the log files and keep them in a safe place!!
Once that's done, rename E00.log to E000003E354.log. Find the E00.chk file and move it out of its current folder (put it with the log file copies you made)! delete ALL log files and leave only the required sequence file...that is on E0000x3e34c.log to E0000x3e354.log files should be in the folder.
Open a command prompt and change the paths to the location of the transaction log files. type ESEUTIL /R E00 to run a recovery. This process simply replays the log files into the database to make it clean.
Once this finishes successfully, change the path to the database file and type ESEUTIL /MH "DatabaseFileName.EDB". Check the STATE of the database and confirm it is in a CLEAN SHUTDOWN state. If so, you are good to mount it!!
Let us know what happens! Good luck!
_____________________________
Ibrahim Benna - Microsoft Exchange MVP Forum Moderator Navantis
1. soft recovery: eseutil /r E00 /d <"drag and drop .edb location"> /l <"drag and drop log files location"> /a /8 (DID NOT WORK)
2. check log files and sequence for errors: eseutil /ml <"program files\Microsoft\Exchange server\Mailbox\First Storage Group\E00 "> (DID NOT WORK) 3. Locate all the missing log files, keep them in that folder, with E00 and move everything else to a separate folder. 4. eseutil /r E00 /d <"drag and drop .edb location"> /l <"drag and drop log files location"> /s <"drag and drop and chk file location"> /a /8 got to a clean state and was able to mount.