The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.
Exchange 2010 DB in clean shutdown state after hard recovery still won't mount
I have an Exchange 2010 server with multiple databases. All but one database was in a dirty shutdown state. I had to run eseutil /p on all databases to get them to report a clean shutdown. One database "DB" still won't mount.
The content index service reports "Failed", however the database does not have a local copy. I'm also concerned that the mounted copy report failed as well.
PS C:\Users\administrator.PF>
Name Status CopyQueue ReplayQueue LastInspectedLogTime ContentIndex
Length Length State
---- ------ --------- ----------- -------------------- ------------
DB1\PF-EXCHANGE Dismounted 0 0 Failed
DB2\PF-EXCHANGE Mounted 0 0 Failed
DB3\PF-EXCHANGE Mounted 0 0 Failed
DB4\PF-EXCHANGE Mounted 0 0 Failed
DB5\PF-EXCHANGE Mounted 0 0 Healthy
[PS] E:\mailboxdb\DB1>eseutil /mh DB1.edb
Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
Version 14.01
Copyright (C) Microsoft Corporation. All Rights Reserved.
Initiating FILE DUMP mode...
Database: DB1.edb
DATABASE HEADER:
Checksum Information:
Expected Checksum: 0x180ed7c7
Actual Checksum: 0x180ed7c7
Fields:
File Type: Database
Checksum: 0x180ed7c7
Format ulMagic: 0x89abcdef
Engine ulMagic: 0x89abcdef
Format ulVersion: 0x620,17
Engine ulVersion: 0x620,17
Created ulVersion: 0x620,17
DB Signature: Create time:07/29/2012 19:13:36 Rand:4222212 Computer:
cbDbPage: 32768
dbtime: 69010018 (0x41d0262)
State: Clean Shutdown
Log Required: 0-0 (0x0-0x0)
Log Committed: 0-0 (0x0-0x0)
Log Recovering: 0 (0x0)
GenMax Creation: 00/00/1900 00:00:00
Shadowed: Yes
Last Objid: 9636
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: (0x1099C,8,1F) 12/29/2012 12:03:25
Last Attach: (0x1099D,9,86) 12/29/2012 11:59:10
Last Detach: (0x0,0,0) 12/29/2012 12:03:25
Dbid: 1
Log Signature: Create time:07/29/2012 19:13:36 Rand:4213550 Computer:
OS Version: (6.1.7601 SP 1 NLS ffffffff.ffffffff)
Previous Full Backup:
Log Gen: 0-0 (0x0-0x0)
Mark: (0x0,0,0)
Mark: 00/00/1900 00:00:00
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: none
Old bad Checksum Error Count: none
Last checksum finish Date: 00/00/1900 00:00:00
Current checksum start Date: 00/00/1900 00:00:00
Current checksum page: 0
Operation completed successfully in 0.125 seconds.
--------------------------
--------------------------
Microsoft Exchange Error
--------------------------
Failed to mount database 'DB1'.
DB1
Failed
Error:
Couldn't mount the database that you specified. Specified database: DB1; Error code: An Active Manager operation failed. Error: The database action failed. Error: Operation failed with message: MapiExceptionJetErrorMissi
. [Database: DB1, Server: EXCHANGE.abc.local].
An Active Manager operation failed. Error: The database action failed. Error: Operation failed with message: MapiExceptionJetErrorMissi
. [Database: DB1, Server: EXCHANGE.abc.local]
An Active Manager operation failed. Error: Operation failed with message: MapiExceptionJetErrorMissi
. [Server: EXCHANGE.abc.local]
MapiExceptionJetErrorMissi
--------------------------
OK
--------------------------
I'm assuming there is a problem with the Content Index for these databases, which is why it won't mount or report the database copies. Exchange Index service has been restarted and is running without error.
Any expert insight and knowledge is greatly appreciated.
The content index service reports "Failed", however the database does not have a local copy. I'm also concerned that the mounted copy report failed as well.
PS C:\Users\administrator.PF>
Name Status CopyQueue ReplayQueue LastInspectedLogTime ContentIndex
Length Length State
---- ------ --------- ----------- -------------------- ------------
DB1\PF-EXCHANGE Dismounted 0 0 Failed
DB2\PF-EXCHANGE Mounted 0 0 Failed
DB3\PF-EXCHANGE Mounted 0 0 Failed
DB4\PF-EXCHANGE Mounted 0 0 Failed
DB5\PF-EXCHANGE Mounted 0 0 Healthy
[PS] E:\mailboxdb\DB1>eseutil /mh DB1.edb
Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
Version 14.01
Copyright (C) Microsoft Corporation. All Rights Reserved.
Initiating FILE DUMP mode...
Database: DB1.edb
DATABASE HEADER:
Checksum Information:
Expected Checksum: 0x180ed7c7
Actual Checksum: 0x180ed7c7
Fields:
File Type: Database
Checksum: 0x180ed7c7
Format ulMagic: 0x89abcdef
Engine ulMagic: 0x89abcdef
Format ulVersion: 0x620,17
Engine ulVersion: 0x620,17
Created ulVersion: 0x620,17
DB Signature: Create time:07/29/2012 19:13:36 Rand:4222212 Computer:
cbDbPage: 32768
dbtime: 69010018 (0x41d0262)
State: Clean Shutdown
Log Required: 0-0 (0x0-0x0)
Log Committed: 0-0 (0x0-0x0)
Log Recovering: 0 (0x0)
GenMax Creation: 00/00/1900 00:00:00
Shadowed: Yes
Last Objid: 9636
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: (0x1099C,8,1F) 12/29/2012 12:03:25
Last Attach: (0x1099D,9,86) 12/29/2012 11:59:10
Last Detach: (0x0,0,0) 12/29/2012 12:03:25
Dbid: 1
Log Signature: Create time:07/29/2012 19:13:36 Rand:4213550 Computer:
OS Version: (6.1.7601 SP 1 NLS ffffffff.ffffffff)
Previous Full Backup:
Log Gen: 0-0 (0x0-0x0)
Mark: (0x0,0,0)
Mark: 00/00/1900 00:00:00
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: none
Old bad Checksum Error Count: none
Last checksum finish Date: 00/00/1900 00:00:00
Current checksum start Date: 00/00/1900 00:00:00
Current checksum page: 0
Operation completed successfully in 0.125 seconds.
--------------------------
--------------------------
Microsoft Exchange Error
--------------------------
Failed to mount database 'DB1'.
DB1
Failed
Error:
Couldn't mount the database that you specified. Specified database: DB1; Error code: An Active Manager operation failed. Error: The database action failed. Error: Operation failed with message: MapiExceptionJetErrorMissi
. [Database: DB1, Server: EXCHANGE.abc.local].
An Active Manager operation failed. Error: The database action failed. Error: Operation failed with message: MapiExceptionJetErrorMissi
. [Database: DB1, Server: EXCHANGE.abc.local]
An Active Manager operation failed. Error: Operation failed with message: MapiExceptionJetErrorMissi
. [Server: EXCHANGE.abc.local]
MapiExceptionJetErrorMissi
--------------------------
OK
--------------------------
I'm assuming there is a problem with the Content Index for these databases, which is why it won't mount or report the database copies. Exchange Index service has been restarted and is running without error.
Any expert insight and knowledge is greatly appreciated.
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Hi,
It looks like you have removed the log file which has not been wrote into database.
If the database has been shut down correctly(clean shutdown), please moved the Checkpoint file and all Logfiles to a different folder and try to mount database again. If the database has not been shut down correctly(dirty shutdown). You may need to restore the database with the backup. Or you need to do a database repair.
We don’t suggest removing log files as that way, regarding how to remove the log files, you can refer to the following article:
How to remove Exchange Server transaction log files
http://support.microsoft.com/kb/240145
or check
please navigate to the folder that contained the database on the command prompt window, then run this command " eseutil /p "mailbox database.edb" "
after the finishing the repair process, clear the Transaction Log Folder by cpying the contents to a temporary folder. With a blank Transaction Log folder, and then try to mount the database for the storage group
It looks like you have removed the log file which has not been wrote into database.
If the database has been shut down correctly(clean shutdown), please moved the Checkpoint file and all Logfiles to a different folder and try to mount database again. If the database has not been shut down correctly(dirty shutdown). You may need to restore the database with the backup. Or you need to do a database repair.
We don’t suggest removing log files as that way, regarding how to remove the log files, you can refer to the following article:
How to remove Exchange Server transaction log files
http://support.microsoft.com/kb/240145
or check
please navigate to the folder that contained the database on the command prompt window, then run this command " eseutil /p "mailbox database.edb" "
after the finishing the repair process, clear the Transaction Log Folder by cpying the contents to a temporary folder. With a blank Transaction Log folder, and then try to mount the database for the storage group
log files were reported missing for several databases after an abrupt shutdown of the server. a soft recovery did not resolve the problem and I had to run a hard recovery using /p switch for eseutil. However, the database still would not mount even though the database was repaired successfully and reported a clean shutdown state. I attributed this issue to the content index state as failed for the database. Since my posting of this question, the database mounted correctly, but I had done nothing futher than wait to see if the content indexing state would update and change from failed to healthy--which it did!
At this point, I am looking for some insight into why this occured and why the database didn't mount. If there is no local or DAG copy of the database and the content index state is reporting FAILED, is there anything that can be done to force the database to mount? I played around with resetting the index, but that didn;t work as there was no copy of the database. I'm a bit miffed at why the database would not mount after the hard repair, yet it mounted without a problem after waiting a few hours. The most insighftul explanation gets the points! :+)
At this point, I am looking for some insight into why this occured and why the database didn't mount. If there is no local or DAG copy of the database and the content index state is reporting FAILED, is there anything that can be done to force the database to mount? I played around with resetting the index, but that didn;t work as there was no copy of the database. I'm a bit miffed at why the database would not mount after the hard repair, yet it mounted without a problem after waiting a few hours. The most insighftul explanation gets the points! :+)
I had to run eseutil /p on all databases to get them to report a clean shutdown. One database "DB1" still won't mount.
I had already ran eseutil /p on the databases that would not mount. eventhough the database reported a clean shutdown state, it still would not mount. I just wanted to clarify that I had already performed all recovery options against the database successfully. I'm still scratching my head at why the database mounted after waiting a few hours. I can only think of the issue related to the content index and exchange index service.
I had already ran eseutil /p on the databases that would not mount. eventhough the database reported a clean shutdown state, it still would not mount. I just wanted to clarify that I had already performed all recovery options against the database successfully. I'm still scratching my head at why the database mounted after waiting a few hours. I can only think of the issue related to the content index and exchange index service.
I have fixed the same issue in past. Initially I try to move the log files to another location and then try to mount. Still unable to mount the database. After that I try to create a recovery database and try to move the mailboxes .Again fail to mount the database.
After that I noticed there is not tmp.edb and e00tmp.log files. I manually created the files and then I moved all the log files to another location. Now the database contains the edb file, tmp.edb file, e00tmp.log file, CHK file. JRS files. This time I try to mount the database and I am successful. Not sure how it s mounted but this is the only change I have made.
After that I noticed there is not tmp.edb and e00tmp.log files. I manually created the files and then I moved all the log files to another location. Now the database contains the edb file, tmp.edb file, e00tmp.log file, CHK file. JRS files. This time I try to mount the database and I am successful. Not sure how it s mounted but this is the only change I have made.
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trial
If DB is clean shutdown simply try to move logs and all other files ".chk .jrs .log .tmp" .... everything apart from .edb and check.
If still doesnt try with a new DB if still not run \prepareAD and that should help
- Rancy
If still doesnt try with a new DB if still not run \prepareAD and that should help
- Rancy
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange
From novice to tech pro — start learning today.
-
Microsoft ApplicationsCertification: MOS Microsoft Office Specialist - Excel 2007 Basic 239 lessons
-
Microsoft ApplicationsCertification: MOS Microsoft Office Specialist - Outlook 2013 Par… 191 lessons
-
Microsoft ApplicationsCertification: MOS Microsoft Office Specialist - Excel 2010 Adva… 183 lessons
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
It looks like you have removed the log file which has not been wrote into database.
If the database has been shut down correctly(clean shutdown), please moved the Checkpoint file and all Logfiles to a different folder and try to mount database again. If the database has not been shut down correctly(dirty shutdown). You may need to restore the database with the backup. Or you need to do a database repair.
We don’t suggest removing log files as that way, regarding how to remove the log files, you can refer to the following article:
How to remove Exchange Server transaction log files
http://support.microsoft.com/kb/240145
Hope this helps. Thanks,