Hy, I need to re-apply transcation log to database for recovering data. I have a database in Clean status. I have transaction log (2gb of transaction log) in another drive. The problem: how I can rebuild the data using the transaction log? Other problem: i don't have all transaction log..I have loste about 50 files. How I can force recover existing log ? obvious we can lost non present data. Thanks LSoLSo Lorenzo Soncini Trento TN - Italy

If your database is in a clean shutdown state, all outstanding transactions have been committed into the database to make it consistent. In that case, you won't need to recover data from your transaction log files. Dismount your database and check with this command: eseutil /mh If it is in a dirty shutdown state, you can replay log files into the database to get the database into consistency forcing a soft recovery using eseutil: eseutil /r /l /d For details see here: Getting an Exchange Database into a Clean Shutdown State using Eseutil http://www.mikepfeiffer.net/2010/04/getting-an-exchange-database-into-a-clean-shutdown-state-using-eseutil/.MCTS: Messaging | MCSE: S+M

The database is an Clean shutdown state (I can mount and use the database ... but the data are 3 month old so I need rebuild from the transaction log). So soft recovery don't apply log (it respond OK in 0.456 sec.). I need force the rebuild of the database indipendently from the state: just get the transaction in the log and foce the data rebuild. LSoLSo Lorenzo Soncini Trento TN - Italy

Sorry, I don't get this: The last update of the database happened 3 months ago. And you have transaction logs from 3 months back up to now? Not taken an Exchange-ware backup for the last three months? MCTS: Messaging | MCSE: S+M

During soft recovery, Exchange uses the checkpoint (.chk) to track which logs have been played into the database already. Whatever logs you do have, make sure there is no gap. Remove the chkpoint file. When you mount the instead of replying from the checkpoint, it will replay them all.

Exact..I don't have a full backup so I need rebuild from old EDB and log. I have moved in Dirty shutdown the EDB and now I try recover data with ESEUTIL. But I get the error : [PS] L:\XCHLOG\PF>eseutil /r E01 /i /a Extensible Storage Engine Utilities for Microsoft(R) Exchange Server Version 14.01 Copyright (C) Microsoft Corporation. All Rights Reserved. Initiating RECOVERY mode... Logfile base name: E01 Log files: <current directory> System files: <current directory> Performing soft recovery... Restore Status (% complete) 0 10 20 30 40 50 60 70 80 90 100 |----|----|----|----|----|----|----|----|----|----| X Recovery has indicated that there might be a lossy recovery option. Run recovery with the /a argument. Operation terminated with error -528 (JET_errMissingLogFile, Current log file missing) after 0.109 seconds. ThanksLSo Lorenzo Soncini Trento TN - Italy

Hi Lorenzo, Since “ eseutil/r E01 /i /a” cannot work for you and you don’t have full backup, you might use eseutil/p to have a try: Run Eseutil/p to repair the database file, Run Eseutil/d on the repair store. Then run Isinteg –fix –tests –altests on the store till reports no errors. You can know more information from this document: Eseutil /P Repair Mode http://technet.microsoft.com/en-us/library/aa996773(EXCHG.65).aspx Thanks, Evan Liu TechNet Subscriber Support in forum If you have any feedback on our support, please contact tngfb@microsoft.com

Hy, ISINTEG is not available on Exchnage 2010 SP1 If I try repari the DB it work (the DB can be remounted) ... but the log are not commited and data are two month old. I need recover data from the available transaction log LSoLSo Lorenzo Soncini Trento TN - Italy

You still have a gap, or you're missing e0n.log J

Yes, this is the problem: we have lost some transaction log. Exactly we have lost from file 3AFF-3D47 and 3D8E - 43EE. The qeustion is: what's the solution? How I can recover data from available log (abount 1Gb of log) ?LSo Lorenzo Soncini Trento TN - Italy

What is the Anchor (required base log) when you run eseutil/mh. What is the range of log numbers that you do have? Does the database signature match the logs? Let's say I have a database and am happy as a clam churning along and I backup my database. All of the committed logs are truncated. Now my database is happily churning writing now logs and so forth, some of them committed and others not... Chaos strikes! What to do? Well, first you need to figure out what logs you have, if there are any gaps, and starting at which log are the logs required. You'll need to stage the logs somewhere for now. If you find that you have logs that have not been committed to the database, what you definitely don't do is an offline defrag. An offline defrag actually copies pages out of the old database and into a new one (which has a new signature) so if you've done that, you won't be able to replay any logs. you do that by running eseutil /mh databasename. Scroll down through the spew and find the entry that says "Log Required". If it's anything other than 0-0, then you can safely remove any log file lower than that number from the directory where you staged the logs. Do you have any gaps? You can only replay logs in contiguous sequences - to the first gap. If the database signature matches the logs you have, stage the logs from the required log to the highest contiguous log number you have. Remove the checkpoint and mount the store or do eseutil -r E0n /i /a Above the required log value, if you have a gap you're going to need to find those logs somewhere (a backup maybe?) and fill the gap to play the logs on the other side of the gap as well. J

Hi Lorenzo, How about the issue, any updates? Thanks, Evan Liu TechNet Subscriber Support in forum If you have any feedback on our support, please contact tngfb@microsoft.com

Hi, we have opened a support ticket in Microsoft and the response is: IS NOT POSSIBLE rebuild the data if some transaction log are missing. LSoLSo Lorenzo Soncini Trento TN - Italy